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: <bsandell_at_gmail.com>
Date: 15 Jul 2005 14:55:05 -0700
Message-ID: <1121464505.293539.173220@f14g2000cwb.googlegroups.com>


It turns out that, besides implicitly converting the result of the UDF, I was also implicitly converting one of my parameters to the UDF. After fixing this and following everyones suggestions, the index is now being used. Thanks very much to everyone for your help in resolving this. Received on Fri Jul 15 2005 - 16:55:05 CDT

Original text of this message

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