Creating an access plan

Use the Command Center notebook to interactively create an access plan for any explainable statement when it is executed.
Note:

  • In Script mode, an explainable statement must be highlighted in order to enable Script->Generate access plan.

  • In Interactive mode, the statement does not need to be highlighted to generate an access plan.



To create an access plan:

  1. Open the Command Center notebook.

  2. Optional. Select the Interactive or Script radio button. The default is Interactive mode.

  3. Optional. To automatically create an access plan whenever an explainable statement is executed, select Script->Options. The Command Center Options notebook opens. Click on the Access Plan tab. Select the Automatically generate access plan check box, and click on OK.

  4. On the Script page, do the following:

    1. Connect to a database. (Type the connect command in the text area and select Script->Execute, or click on the icon, or press the Ctrl+Enter keys to execute it.)

    2. Type an explainable statement in the text area or select from an existing statement. Note: In Interactive mode, each statement must end with a semi-colon (;), except the last statement.

    3. To create an access plan without executing the statement, select Script->Create access plan or click on the icon. The access plan graph is displayed on the Access Plan page.

    4. To create an access plan and also execute the statement: select Script->Execute or click on the icon. The results are displayed on the Results page. If Automatically generate access plan is enabled, click on the Access plan tab to see the access plan graph. Otherwise, select Script->Create access plan or click on the icon. The access plan graph is displayed on the Access Plan page.


Related information