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: what is fastest way to search text field with 'like'

Re: what is fastest way to search text field with 'like'

From: Joachim Pense <joachim.pense_at_t-online.de>
Date: Sun, 3 Jun 2001 22:41:14 +0200
Message-ID: <9fe7db$3l8$02$1@news.t-online.com> 






sdfsd wrote:



> 

> we have 2 million rows with a comoany name column the problem is that

> there maybe different spellings for the same company name, i.e. jewel,

> jewels, jewel inc., etc.

> 

> indexing doesn't help, and like does full scan.  any ideas to deal with




What is the execution plan? Why does like do a full scan? Why does
indexing not help?



Joachim
Received on Sun Jun 03 2001 - 15:41:14 CDT












Original text of this message













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