On 6/30/06, Mladen Gogala <gogala_at_sbcglobal.net> wrote:
> It's not indeterministic, but is extremely complex and its very hard to predict
> the output. What I really need is a "use an index if it exists" parameter that
> Oracle doesn't want to give us.
That sounds rather like the /*+ INDEX table_alias(colum list) */ hint
that is available with 10.1 and above to me.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 30 2006 - 00:37:39 CDT
