Changing the appearance of a graph

Use the Access Plan Graph Settings notebook to change settings that affect the content and appearance of the access plan graph.

Fields and controls

To change various characteristics of how a graph appears:

  1. Open the Access Plan Graph Settings notebook.

  2. To change the background color, choose the Graph tab.

  3. To change the color of various operators, use the Basic, Extended, Update, and Miscellaneous tabs.

    Note: On OS/2, these tabs appear after you select the Operator tab.

  4. To change the color of table, index, or table function nodes, select the Operand tab.

  5. To specify which type of information is shown in operator nodes (type of cost or cardinality, which is the estimated number of rows returned so far), choose the Operator tab.

  6. To specify whether or not schema names or user IDs are shown in table nodes, select the Operand tab.

  7. To specify whether nodes are shown two-dimensionally or three-dimensionally, select the Node tab.

  8. To update the graph with the options you chose and save the settings, click on Apply.



Related information