Re: Index on more than one column

In article <4impri$f7b_at_castle.nando.net>, Chris Fischer (cfischer_at_nando.net) says...
!>
!>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.
!>

You don't easily change your mind, do you, Chris?

-- 
Kind reGards
     \ /   |
      X    |
     / \   s
     Gerard