Measuring performance

• Use Quest Software SQL Navigator to check performance of SQL scripts

• Make sure you have a realistic amount of data in the database

• Adjust your query to achieve best possible scan on most of or all tables

• Avoid TABLE ACCESS(FULL) on tables holding large amounts of data

• Measure time to completion

Notes: