Which version of Oracle ?
What value for the COMPATIBLE parameter ?
What were the two execution plans ?
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )
____UK_______March 19th
____USA_(FL)_May 2nd
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____USA_(CA, TX)_August
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Chuck wrote in message ...
>Why would enabling STAR_TRANSFORMATION_ENABLED for a non-star query
produce
>a significantly faster query? I have a query that went from about 10
>seconds to < 1 second after enabling it. The documentation's
description
>for the parameter is...
>
Received on Tue Feb 04 2003 - 15:58:18 CST
