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 -> Substring searching on large table

Substring searching on large table

From: anthony burns <tonyburns_at_trenchave9.freeserve.co.uk>
Date: Sun, 16 May 1999 17:36:51 +0100
Message-ID: <7hms0r$ge6$1@news6.svr.pol.co.uk> 





I have a problem with searching on a very large table 3 million + rows. I
want to find substrings within a particular field within the table eg:



select name from customer where street like '%AVENUE%'



does anyone have any tips for this type of query. The query takes about
30secs at the minute which is way too long, any tips would be much
appreciated,



cheers,



Tony.


Received on Sun May 16 1999 - 11:36:51 CDT












Original text of this message













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