Hello All,
I hope this find you all in good spirits
I have some SQL that I need to optimize.
In your Personal experience what is the best way to find all the "True" bottlenecks within the SQL itself.
This is my Work-Flow:
Step 1:
Explain Plain: Find all the Full Table scans right up front.
Step 2:
Execute the SQL through Grid Control at the point where you can just "execute" SQL right there.
Step 3:
Create a SQL Tuning set with the SQL Code that has just been executed.
Step 4:
Execute SQL Access Advisor and use the SQL code that has just been executed.
Step 5:
Run the SQL through SQL Tuning Advisor.
I know there are many way to do this, but what is your "Work-Flow".
Thanks for any and all help...
Thanks,
Lady Allora.