Tchater maintenant avec le support
Tchattez avec un ingénieur du support

SQL Optimizer for SAP ASE 3.8 - 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

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation