Is the value that doesn't correspond to any indexes 0 because 0 indicates a
Maybe both questions are answered? Let us know!
Please reply only on the newsgroups! Include dml/ddl, when possible.Thanks
Kimberly L. Tripp
President, SYSolutions, Inc. [url]www.SQLSkills.com[/url]
Principal Mentor, Solid Quality Learning [url]www.SolidQualityLearning.com[/url]
"Amos Soma" <nospam> wrote in message
news:%23UHcjlkRDHA.1624tk2msftngp13.phx.gbl...> I have a couple questions regarding understanding Scan profiler output.
> 1) Sometimes the IndexID data column will contain a value that does not
> correspond to any index on the associated table. Why is this?
> 2) How can I tell when a table scan is being done?
> Thanks very much.