Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Function based index not being used
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