Re: Index on more than one column
From: Donna Kray <kray.donna_at_mlink.motors.ge.com>
Date: 1996/03/21
Message-ID: <4irn6g$7uo_at_crissy.ge.com>#1/1
>
>Will this index be ignored when I only use firstname= in a
>where clause?
>
>
>Kjetil Skotheim, 22239859 (hjemme), 22852823 (jobb)
Received on Thu Mar 21 1996 - 00:00:00 CET
Date: 1996/03/21
Message-ID: <4irn6g$7uo_at_crissy.ge.com>#1/1
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
>
>Kjetil Skotheim, 22239859 (hjemme), 22852823 (jobb)
Received on Thu Mar 21 1996 - 00:00:00 CET