Tech Brief

Optimizing SQL Statements in SQR

This technical brief describes the process for using Quest SQL Optimizer to ensure that reports created using Structured Query Report utilize the best possible performing SQL statements. By analyzing SQL statements embedded within database objects, test or binary files, and application source code, you will be able to easily determine which SQL statements are likely to cause bottlenecks or performance issues. SQL Optimizer then automates the process of optimizing problematic or complex SQL.