Re: Index on more than one column

Kjetil.Skotheim_at_usit.uio.no (Kjetil Skotheim) wrote:

>If for instance I have done a
 

> create index on person (lastname, firstname)
 

>Will this index be ignored when I only use lastname= in a
>where clause?

No.

>Will this index be ignored when I only use firstname= in a
>where clause?

Yes.

+------------------------------------------------------------+
| Chris Fischer                           cfischer_at_nando.net |
| Sr. Systems Analyst                    Work: (919)676-0062 |
| Toys "R" Us                                                |
+------------------------------------------------------------+