Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Function based index not being used

Re: Function based index not being used

From: Barbara Boehmer <baboehme_at_hotmail.com>
Date: 10 Jul 2005 16:48:12 -0700
Message-ID: <1121039292.622402.68800@g14g2000cwa.googlegroups.com>


As pointed out by Jonathan Lewis in your thread on the same topic in another forum, a better method of avoiding the implicit conversion that prevents the index from being used is to use hextoraw or rawtohex on one side of the comparison or the other, instead of using substr. Here is a link to that thread:

http://groups-beta.google.com/group/comp.databases.oracle.server/browse_frm/thread/49abe49c9e0b29d6/16427463354af1eb#16427463354af1eb Received on Sun Jul 10 2005 - 18:48:12 CDT

Original text of this message

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