Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Release Notes

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

  1. Select the SQL statement you want to generate indexes for.

  2. Click Send to Index Advisor image\B_CopytoIndexAdvisor.gif.

Note: The Index Advisor only supports a single SELECT, INSERT, UPDATE and DELETE SQL statement.

 

Related Topic

Related Documents