SQL TUNNING ADVISOR
Hi All,
I have ran sql tuning advisor through TOAD and i got the below output
FINDINGS SECTION (1 finding)
-------------------------------------------------------------------------------
1- SQL Profile Finding (see explain plans section below)
--------------------------------------------------------
A potentially better execution plan was found for this statement.
Recommendation (estimated benefit: 20.25%)
------------------------------------------
- Consider accepting the recommended SQL profile.
execute dbms_sqltune.accept_sql_profile(task_name =>
'W2QZKMM90314340091.6132862037', replace => TRUE);
I am not able to understand the recommendation,and how i will know the full description, means what are the
recommendation given by oracle
I am appreciated if some one help me to find the solution
Regards,
Makesh boopathi.k.s.