Subject Re: about computed fields performance
Author Adam
--- In, "Anderson Farias"
<peixedragao@...> wrote:
> Hi Sean, thanks for your input...
> ...sorry, I may be loosing something here... how am I suposed to
> verify by running a SQL like I mentioned before, if the computed
> fields are calculated or not??
> Could you give me some glue on this simple test I should run?

Add a computed field that is computed by selecting the sum of a field
in another large table, and compare the select speeds with and without
this field returned. If the optimisation to not bother with the
computed field if not selected is indeed there, then there will be a
marked difference in speed. There may or may not be a different plan,
I do not know.