At 08:34 PM 6/28/00 +1000, Daniel_Work@... wrote:

>not sure? I throught PLANs related to which indexes are used.
>
>Do plans contain which tables, columns, UDFs, Generators, SPs, etc that are
>required by a SQL statement?

Tables, yes, and columns by implication through indexes, but
otherwise, no, they don't. Nor do they reveal partial key matches or
unkeyed comparisons that are used as a final filter.

Ann