On 6/30/06, Mladen Gogala <gogala@xxxxxxxxxxxxx> 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