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 -> Indexes with LIKE statements

Indexes with LIKE statements

From: Nikita <Nikita_at_yahoo.com>
Date: 2000/03/23
Message-ID: <38DA6B59.EFFEA347@yahoo.com>#1/1 






Running Oracle 8.0.5 on Solaris 2.7



Creating a b-tree index on a varchar2 column, with high cardinality data



being searched with LIKE statements.


Does this make sense, and would the use of this index need to be forced
with hints?



TIA

Received on Thu Mar 23 2000 - 00:00:00 CST












Original text of this message













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