SQL Server Scanning Tables

[Miks]

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

[Dan Guzman]

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" <ak********@gmail.com> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...

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