Toad World® Forums

Quest SQL Optimzier for SQL Server Version 8.5.0 has been released.

Hi Everyone,

SQL Optimizer for SQL Server version 8.5.0 is now available.

In this release, we add a brand new module, Optimize Indexes. It analyzes a SQL workload or any group of SQL statements and determines the best index set for the workload or group of statements. Some of the user interface also enhanced and has a better support for SQL Server 2012.

  • Previous versions have supported optimizing only one SQL statement at a time. You can now input multiple SQL statements for optimization.
  • Optimizer now able to automatically detects bind variable data type and it’s value as well as undefined tempoaray tables referenced in a SQL statement.
  • When generating indexes for a SQL, the engine now considers all the tables referenced inside a view.

We are looking forward to hearing your feedback. Please feel free to download our trial version and have a try.