SEO

#1 (**permalink**) 02-29-2008, 06:40 PM

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

#2 (**permalink**) 02-29-2008, 06:41 PM

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@gmail.com> wrote in message
news:1142000802.225419.230410@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
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

SQL Server Scanning Tables