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

Home -> Community -> Usenet -> c.d.o.misc -> LIKE performance

LIKE performance

From: lh <lh_at_nowhere.com>
Date: Fri, 25 Feb 2005 09:25:28 +1000
Message-ID: <tptTd.9031$i6.101523@nasal.pacific.net.au> 





I have a table with about 30000 rows, one column is a varchar2(90).  I'm 
doing a LIKE 'XXX%' query and its not using an index.



I tried querying with substr(col, 1, 10) = 'XXXXXXXXXX' with an index on 
substr(col, 1, 10).  It doesn't use the index, even with a hint.



Whats the best way to get good performance out of this type of query.



TIA



LH 
Received on Thu Feb 24 2005 - 17:25:28 CST












Original text of this message













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