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: why 's%' use index '%s' doesn't?

Re: why 's%' use index '%s' doesn't?

From: rob <rob_at_dsdelft.nl>
Date: Fri, 27 Jul 2001 09:26:46 +0200
Message-ID: <9jr53m$ncg$1@news.tudelft.nl>

> When I use like operator, I found that search by 's%' is so much
> different from '%s'. Why is that and how to resolve this? Any help
> is appreciated(no CBO please). Thanks.
Look at it like this :
If you have a dictionary looking up a word when you know the first character is much easier then when you know the last character. ;-)

Rob. Received on Fri Jul 27 2001 - 02:26:46 CDT

Original text of this message

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