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: will "like" always use full table scan instead of function-based index?

Re: will "like" always use full table scan instead of function-based index?

From: Tom McCready <noone_at_nowhere.com>
Date: Fri, 20 Feb 2004 10:39:26 -0500
Message-ID: <c159gd$j7la$1@rs7.loc.gov> 







Bib Endum wrote:



> You have a function based index using the rawtochar() function, but in 

> your

>

>select you use the chartoraw() function.

>



Bib,



Thank you for your reply.



Tom
Received on Fri Feb 20 2004 - 09:39:26 CST












Original text of this message













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