Hi Friends ,
My customer is on oracle R12.1. I am in the mid of tuning a SELECT SQL
statement . Used SQL Tuning advisor and it says accepting a
profile will result in 90% improvement. Before even I accept the profile, I
want to understand what it does and want to do the
same - if possible - without profiles .
I am trying to understand the OPT_ESTIMATE part of the advisor
(dba_advisor_rationale) . Hard though , as I could not find much about
it on internet. Looks like SCALE_ROWS part of it does the magic . Can anyone
explain or point me to a doc/URL which helps how to read
and understand the OPT_ESTIMATE line .
How can one give optimizer the info' ... which OPT_ESTIMATE can give ? How do
you guys approach this .
Thanks and Regards,