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

Home -> Community -> Usenet -> c.d.o.server -> Re: Need index on 2 column table?

Re: Need index on 2 column table?

From: Wally <wallyraju_at_gmail.com>
Date: 4 Aug 2005 14:14:48 -0700
Message-ID: <1123190088.912794.232800@g47g2000cwa.googlegroups.com> 





You are bound to have a primary key on the table. The primary key
column is gonna be indexed by default. If this is the column you are
searching on then you dont have to create another index. If the column
you are searching on is the other one, then you might wanna create an
index.



HTH


Wally
Received on Thu Aug 04 2005 - 16:14:48 CDT












Original text of this message













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