SQL Statement Tuning Methodology

A basic SQL Statement Tuning Methodology

* Auto trace the statement.

Run the statement with autotrace on. Look
for obvious problems with the statement.

- Full table scans of large tables that
that return only a few rows.

- Accessing a view and also accessing one
of the views underlying tables again.

* Indexes

-Do the Jion columns have indexes?

-Do the WHERE clause columns have indexes?


* Are Statistics correct and up-to-date?

-

* Check the Wait events

-

* Can we partition the table?

- Is it a date based table
- Range, Hash, List, Composite





******************************************
keywords:
******************************************
rdbms version:
******************************************