Posted by Miks on 03/10/06 16:26

Hi,

When we make a search for a table in SQL Server 2000

sysindexes table is searched and indid field is checked,

If it's 0 we go for full table scan (No Indexes Present)

If it's 1 it means clustured index column is used for search.

2-254 means non-clustred indexes used.

Thank you very much for taking time and replying.

Thank you,
Miks

[Back to original message]