What's New in Rapid SQL 2016
Go Up to Main Page
PostgreSQL Object Management
The Missing Indexes feature analyze the system looking for Missing Indexes which, once added, would improve the performance.
Rapid SQL proposes you some Indexes that can be created created after analyzing the system. You can create these Indexes by launching the Indexes Wizard (SQL Server) and directly double-clicking the selected Missing Index.
Description about how to use and access Missing Indexes is in Missing Indexes (SQL Server).
Note: Missing Indexes is only available for SQL Server.
SQL Editor includes new functionalities for SQL Server. In this new release, SQL editor provides information about the SQL statements while you are writing in the SQL Editor. This information is included in a new window as well as listed in the Error Pane. Information like Missing Indexes, Statistics, Overlapping Statistics and Recommendations are displayed in this new window. You can find more information in ISQL Performance
ISQL Performance listed in Error Pane
Note: ISQL Performance only available for SQL Server.
Team Server 2016 Support
Integration of Team Server 2016 in Rapid SQL has been improved. The old TeamServer Navigator has been fully integrated into the Datasource Navigator as well as all the features only accessible from the TeamServer Navigator. For more information, see Using the Datasource Navigator and Basic Viewing Options in the Navigator. Notice that when logged in Team Server 2016, a node is added:
- Saved Searches
Team Server 2016 as the Data Source Catalog
Rapid SQL 2016 adds the option of registering datasources from the Team Server 2016 Repository. To allow that, new options have been added to Quick Start Setup, and in Tools > Options > Datasources.
In Quick Start Setup, the import of datasources using Team Server 2016 as a catalog has been added.
In Tools > Options > Datasources the possibility of selecting Team Server 2016 as the source of the catalog has also been added. For more information, see Working with Team Server 2016 as Datasource Catalog.