Hello everyone.
I've got a question that I've been wondering about for a while, and have not been able to find the answer.
So, I'm hoping someone here will know.
Here is the scenario.
I've got an SQL view, ViewABC, which has a calculated column (eg. calculating a duration between dates or times).
This view, ViewABC, is then included as part of another SQL view, ViewXYZ, but the calculated column is not used in ViewXYZ.
The question therefore is, does the calculated column from ViewABC still get calculated for each ViewABC row that is retrieved as part of a query against ViewXYZ?
Thanks in advance.
Walt
I've got a question that I've been wondering about for a while, and have not been able to find the answer.
So, I'm hoping someone here will know.
Here is the scenario.
I've got an SQL view, ViewABC, which has a calculated column (eg. calculating a duration between dates or times).
This view, ViewABC, is then included as part of another SQL view, ViewXYZ, but the calculated column is not used in ViewXYZ.
The question therefore is, does the calculated column from ViewABC still get calculated for each ViewABC row that is retrieved as part of a query against ViewXYZ?
Thanks in advance.
Walt
Comment