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.