SQL Optimizer for SQL Server version 7.1.0 is now available.
In this release, we implemented two major featues as well as some of the some of the user interface enhancements and SQL Server 2008 R2 support.
- You can now create virtual indexes for user defined alternatives in Optimize SQL. The Virtual Indexes and Index Script tabs are also available for system generated index alternatives
- User defined alternatives now support functional-based indexes.
- Execution plan outdated reminder, for example, when you modified your SQL text again after the execution plan retrieved. SQL Optimizer will show a message at the top of the execution plan pane to alter you.
Also feel free to talk to us at “Talk to Our Developers”.