Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> index question

index question

From: paul <pjohnpeter_at_qssnet.com>
Date: Tue, 25 Jul 2000 21:03:48 -0400
Message-Id: <10569.112964@fatcity.com>


hi gurus,
 this is my question.
Will "Changing the column order in the index definition" affect the result?

E.g.,

Are the following statements same or what?

  Create unique index abc on table1(empno, ename)

  Create unique index abc on table1(ename, empno) Received on Tue Jul 25 2000 - 20:03:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US