Quest SQL Optimizer for DB2 LUW maximizes SQL performance by automating the manual, time-intensive and uncertain process of ensuring that SQL statements are performing as fast as possible. Refer to the Quest SQL Optimizer for DB2 LUW 4.2 Release Notes to see what's new in this release.
SQL Inspector
• The SQL Inspector captures executed or currently-running SQL statements from the database. You can specify criteria to retrieve SQL statements and execution statistics to review SQL performance.
End-User Usage Statistic Collections
• SQL Optimizer for DB2 LUW now collects anonymous and aggregated data about the use of different features within SQL Optimizer for DB2 LUW. The data is briefly stored on the Amazon Cloud before being moved to servers in the US maintained by PreEmptive Solutions. The data is available to our product team to analyze our user community?s preferences and common practices which will influence our future releases.
Other updates
• Windows 8 support
• Windows Server 2012 support
