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 ! :)
0 comments:
கருத்துரையிடுக