Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: why 's%' use index '%s' doesn't?
> 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
![]() |
![]() |