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

What is your question?

SQL Server may choose to use available indexes in different ways depending
on the query. A scan of the entire clustered index is the same as a
scanning of a table without a clustered index.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Miks" <akmeera2k4 (AT) gmail (DOT) com> wrote