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: Case sensitive

Re: Case sensitive

From: David Ng <david_ng_at_mindlink.bc.ca>
Date: 1996/11/17
Message-ID: <329016AC.266B@mindlink.bc.ca>#1/1 







Jeff Murphy wrote:


> 

> Antonio Melo (avm_at_novabase.pt) wrote:

> >  2. use " where upper(name) like 'MAR%' " => performance problems...

> 

> what are the performance implications of using this technique to provide

> case insensitive searches?




Oracle optimizer can not use index in this case, and performance suffers



David Ng
Received on Sun Nov 17 1996 - 00:00:00 CST












Original text of this message













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