Improving Database Performance: SQL Query Optimization
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.
KeywordsQuery Processing Execution Plan Query Optimization Trace File Performance Tuning
Unable to display preview. Download preview PDF.