Creating an access plan using the Command Center

To create an access plan,

1. Open the Command Center notebook.

2. Select the Interactive radio button.

3. 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 the command.)

   2. To create an access plan without executing the statement, type an explainable statement in the text area and select Script->Create access plan, or click on the icon. The access plan graph is displayed on the Access Plan page.

      You can also select an explainable statement from an existing script.

   3. To create an access plan and also execute the statement:

      1. 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.

      2. Type an explainable statement in the text area or select an existing statement. Select Script->Execute, or click on the icon. The results are displayed on the Results page. To view the generated access plan, click on the Access Plan tab.

More information on using the Command Center is found in Command Center -- Overview.