How do I find SQL performance problems prior to migrating programs to production?
SQL Performance analysis should start as early as possible in the development cycle. Performance problems can reside within the SQL statements itself as well as the access paths. Prior to moving to production, you should run an Explain on each program and the access paths should be checked for possible performance problems. The PLAN_TABLE identifies where work is being performed within each access path. You can also use Platinum’s Plan Analyzer tool to do the Explain and get an interpreted report back instead of looking at the PLAN_TABLE entries and interpreting them manually.
