Oracle Performance Tuning Check list atoz Help

Oracle PERFORMANCE REVIEW CHECKLIST

Using Explain Plans to Analyze the Sql Statements Read frequently used values only once Avoid usage of functions in WHERE Clause Calling a custom PL/SQL functions in WHERE Clause Reduce Number of Database Calls, if possible combine statements  Avoid unnecessary Group Functions Check Index Usage Include only required tables in FROM clause Consider whether a UNION ALL will suffice in place of a UNION.   Avoid joins that require the DISTINCT qualifier on the SELECT list in queries. Avoid including HAVING clause if possible. Use cursors with bind variables to avoid hard parsing In many cases EXISTS is preferred against IN, use EXISTS or IN as required. Place commit statements at appropriate intervals when using a code that performs bulk DMLs. Use Tkprof Utility to view performance statistics. Use Explain Plans to Analyze the Sql Statements. Select the driving tables and use Table Aliases Avoid Calculations and using NOT on Indexes Columns. Avoiding Full Table Scans. Minimizing the number of table lookups when sub-queries are used. Avoid converting Index Column Types.

Oracle Tuning

                                                           
Note : Provide your comments by clicking below options! Thanks ! :)

Tweet