7
Verifying Performance

The purpose of this brief chapter is to remind you of the importance of verifying that your tuning efforts have indeed improved the performance of your statements, and to point out the ways you can use Oracle SQL Analyze to verify performance improvements.

How to Verify SQL Performance Improvement

You can use the same methods used for gathering information to verify that the performance of your statement has been improved:

• Execute the new statements and compare the results, as shown in Viewing Execution Statistics.
• Generate new explain plans and compare them as described in Generating an Explain Plan.
• Review the object details to ensure they're being used efficiently, as described in Examining Views.