SQL Server Scanning Tables - 03-10-2006 , 08:26 AM
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.
Re: SQL Server Scanning Tables - 03-12-2006 , 07:19 AM
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.
SQL Server MVP
"Miks" <akmeera2k4 (AT) gmail (DOT) com> wrote