Improving Database Performance: SQL Query Optimization

  • Sam R. Alapati


Performance tuning is the one area where the Oracle DBA will probably spend the most of his or her time, whether the DBA is working with a development or a production database. Performance tuning could be proactive as well as reactive. If you’re a DBA helping developers to tune their SQL, you can improve performance by suggesting more efficient queries or table- and index-organization schemes. If you’re a production DBA, you’ll be dealing with user perceptions of a “slow” database, batch jobs taking longer and longer to complete, and so on.


Query Processing Execution Plan Query Optimization Trace File Performance Tuning 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Sam R. Alapati 2003

Authors and Affiliations

  • Sam R. Alapati

There are no affiliations available

Personalised recommendations