Top 10 Best Way To Handle Performance Tunning Of Sql Query




Step 1. Check explain plan.



Explain plan is representation of path which taken by optimizer to execute sql query.



Step 2. Read explain plan carefully and step by step.



Step 3. identify that table which is under full scan.



Step 4. identify that table which is under cartesian product.



Step 5. Check index is present or not.



Step 6. Check index on table which was used in that query.



Step 7. Need to check what types of join used by optimizer.



Step 8. IN,NOT IN,EXIST,NOT EXIST was at proper place or not.



Step 9. Is there any HINT used or not.



Step 10. Statistics Gathering is updated or not ,this is very important in performance tuning.