Creating an access plan

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

To automatically create an access plan whenever an explainable statement is executed, select Automatically generate access plan from the Access Plan page of the Command Center Options notebook.
Note:
  • On the Script page, an explainable statement must be highlighted in order to enable Script->Generate access plan.
  • On the Interactive page, 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. Select the Interactive page or the Script page of the Command Center notebook.
  3. Connect to a database. (Type the connect command in the text area and select Execute from the Script or Interactive menu, click the icon, or press the Ctrl+Enter keys to execute it.)
  4. Type an explainable statement in the Command field. On the Interactive page you can also select an existing statement from the Command history list.
    Note:On the Interactive page, each statement must end with a semi-colon (;), except the last statement.
  5. Select Execute from the Script or Interactive menu or click the

    .
    Note:You can create an access plan without executing an SQL statement by clicking: . This will cause an access plan graph of the last command that was executed to be displayed on the Access Plan page of the Command Center notebook.

  6. If Automatically generate access plan is enabled in the Command Center Options notebook, click the Access plan tab of the Control Center notebook to see the access plan graph. Otherwise, click the

    to create the access plan graph.

  7. The access plan graph is displayed on the Access Plan page.



Related information