Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> Transact-SQL

covering indexes

Hi,
I asked the similar question before but I have again some doubts about covering indexes.
Besides, tomorrow I have a Microsoft MCAD 70-229 exam so please help me.
In here,
SELECT * FROM Order WHERE OrderID > 12 ORDER BY OrderDate

we create composite nonclustered index for both OrderID andOrderDate column.
Leftmost isOrderID.
So

when our first research is happening(Where clause), the only

nonclustered index which is used is OrderID index. And then, when we

pass through the second search(ORDER BY clause), OrderDate index become activated.
So

we can say that the seleection of indexes in composite indexes is

determined according to the situation of the query at that time.

Hence, is this all correct ?

Best wishes,
Mert

[1358 byte] By [mert-1] at [2007-12-22]
«« Windows share point services
»» Question about "scanf" function.
# 1
Hmm,
Now thanks to the strict studies on indexes, I conceived that my approach to this is completely false.
So again in my opinion, the best solution for the above query is that we must use two separate indexes and for Ordeing we should use nonclustered index since it brings much performance benefit, for instance; we do not have to look up the data table since we will have a available ordered set.
So would you please explain your own opinions ?

Thanks

mert-1 at 2007-8-30 > top of Msdn Tech,SQL Server,Transact-SQL...
SQL Server
Transact-SQL

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified