Generate Indexes in Optimize SQL

SQL Optimizer identifies columns to use as index alternatives for a SQL statement after it analyzes SQL syntax, relationships between tables, and selectivity of data. SQL Optimizer then combines identified alternatives into index sets.

To generate an index alternative

1. Select the Optimize SQL tab in the main window.

2. Enter a SQL statement in the Alternative Details pane.

3. Click . The Select Connection and Schema window displays.

4. Select a connection and schema to use.

5. Select Index Details in the SQL Information pane to view index generation information.

6. Select an index set to test in the Alternatives pane.

7. Click .

   Note: The Execute function allows you to test an index set SQL Optimizer generated. It physically creates the indexes on the database, runs the SQL statement, retrieves execution statistics, and drops the indexes. Since this process physically creates indexes on your database, it may impact performance of other SQL statements.