Home -> Usenet -> comp.databases.oracle -> Index on more than one column

Index on more than one column

From: Kjetil Skotheim <Kjetil.Skotheim_at_usit.uio.no>
Date: 1996/03/19
Message-ID: <Kjetil.Skotheim-1903961513270001_at_macusit46.uio.no>#1/1 







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?



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





(please resond in email if you can).


--
Kjetil Skotheim, 22239859 (hjemme), 22852823 (jobb)


Received on Tue Mar 19 1996 - 00:00:00 CET












Original text of this message