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.