Thanks for the feedback.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
dias wrote in message <55a68b47.0202060221.7bba6c2e_at_posting.google.com>...
>Hi,
>
>I found a solution to my probleme ... and I have now the same
>performance in 8.1.7 and 8.1.6 databases.
>
>The main diffrence between the two releases was the hidden parameter
> _or_expand_nvl_predicate
>
>In 8.1.7, the value is "TRUE". It was "FALSE" in 8.1.6.
>
>In my application, I have a lot of queries with " ... where nlv(...)"
>and with this parameter to TRUE, Oracle rewrite the queries.
>
>The Note:94064.1 on metalink explain the effect of this parameter
>
Received on Wed Feb 06 2002 - 07:30:03 CST
