|
Posted by Dan Guzman on 03/12/06 15:19
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.googlegroups.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
>
Navigation:
[Reply to this message]
|