Chatta subito con l'assistenza
Chat con il supporto

SQL Optimizer for DB2 LUW 4.4 - Installation Guide

Regenerate

The Scenario can be re-executed using the same indexes. You can choose to retrieve the access plans for all SQL statements in the Scenario or select specific SQL to retrieve the access plan again using the same indexes.

The function is useful if changes have occurred in the database environment, such as data volume changes, that may affect access plans.

To regenerate the access plan

  1. Select the Scenario from the left pane.

  2. Right-click and select Regenerate.

  3. Check the SQL statements whose current access plans you would like retrieved again.

 

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione