Posted by Baihao Yuan on 06/08/06 22:50

Hi,

I created a composite index (lastname, firstname). I know the following
queries will use this index:

WHERE lastname = ...
WHERE lastname = ... AND firstname = ...

Also this won't use the index:
WHERE firstname = ...

But how about: WHERE firstname = .. AND lastname = ...

And why?

Thanks a lot,

Baihao


--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

• Next in forum: Re: SQL Union Problems When Trying to Retrieve Random Records
• Prev in forum: Re: Disabling the AUTOCOMMIT option in MSSQLServer
• Thread view: composite index and column order

[Reply to this message]