Send to Index Advisor
Performance improvement for a SQL statement could be obtained by creating indexes to reduce I/O consumption. By sending a SQL statement to the Index Advisor module, you can obtain recommendations for new indexes that could change SQL performance.
If you are in a module that has a SQL Text pane, you can send a SQL statement to the Index Advisor.
To send a SQL statement to the Index Advisor and automatically start the index recommendation process
-
Select the SQL statement you want to generate indexes for.
-
Click Send to Index Advisor
.
Note: The Index Advisor only supports a single SELECT, INSERT, UPDATE and DELETE SQL statement.