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 -> how to improve "select num from telebook where num like '%345%'"

how to improve "select num from telebook where num like '%345%'"

From: <qiangye_at_my-deja.com>
Date: Wed, 06 Sep 2000 08:52:58 GMT
Message-ID: <8p50l5$sdg$1@nnrp1.deja.com> 






We have a huge table storing all of the telephone numbers of the city.
The query is to retrieve all the numbers which contain "345" in the
middle position. The current performance is too slow. Anybody knows how
to improve the performance like that query?



Thanks in advance!





Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Wed Sep 06 2000 - 03:52:58 CDT












Original text of this message













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