Access Plan Graph Settings -- Fields and controls

" " Graph page
" " Node page
" " Operator page
" " Operand page
" " Basic page
" " Extended page
" " Update page
" " Miscellaneous page
" " OK
" " Cancel
" " Apply
" " Reset
" " Defaults


Graph page

" " Background color
" " Header

" " Background color

This box contains a list of colors. To change the background color of the graph, click on the down arrow to display a list of available colors and select one.

" " Header

Select one or more of these check boxes to indicate what is shown in the area at the top of the Access Plan Graph window.

Identification
Displays the database name, package name including the section number, explain date and time, and type of parallelism.

Total cost
Displays the total cost in timerons.

Zoom slider
Displays the zoom slider.


Node page

" " Style

" " Style

The style field allows you to specify whether the nodes appear in a two-dimensional or three-dimensional style.

Operator page

" " Content

" " Content

The operator content field allows you to specify the type of information that is shown in the operator nodes.

Operand page

" " Content
" " Table color
" " Index color
" " Table function color

" " Content

The operand content field allows you to specify the type of information that is shown in the table and table function nodes. Select Name only to view only the name, or Schema and name to view the name and its schema.

Only the index name is shown in index nodes

" " Table color

This box contains a list of colors. To change the color of table nodes in the graph, use one of these methods:

" " Index color

This box contains a list of colors. To change the color of index nodes in the graph, use one of these methods:

" " Table function color

This box contains a list of colors. To change the color of table function nodes in the graph, use one of these methods:



Basic page

Color of Operator nodes:

" " TBSCAN
" " IXSCAN
" " RIDSCN
" " FETCH
" " IXAND

" " TBSCAN

This box contains a list of colors. To change the color of TBSCAN nodes in the graph, use one of these methods:

" " IXSCAN

This box contains a list of colors. To change the color of IXSCAN nodes in the graph, use one of these methods:

" " RIDSCN

This box contains a list of colors. To change the color of RIDSCN nodes in the graph, use one of these methods:

" " FETCH

This box contains a list of colors. To change the color of FETCH nodes in the graph, use one of these methods:

" " IXAND

This box contains a list of colors. To change the color of IXAND nodes in the graph, use one of these methods:



Extended page

Color of Operator nodes:

" " MSJOIN
" " NLJOIN
" " HSJOIN
" " TQUEUE
" " FILTER
" " GRPBY
" " SORT
" " RQUERY
" " EISCAN

" " MSJOIN

This box contains a list of colors. To change the color of MSJOIN nodes in the graph, use one of these methods:

" " NLJOIN

This box contains a list of colors. To change the color of NLJOIN nodes in the graph, use one of these methods:

" " HSJOIN

This box contains a list of colors. To change the color of HSJOIN nodes in the graph, use one of these methods:

" " TQUEUE

This box contains a list of colors. To change the color of table queue nodes in the graph, use one of these methods:

" " FILTER

This box contains a list of colors. To change the color of FILTER nodes in the graph, use one of these methods:

" " GRPBY

This box contains a list of colors. To change the color of GRPBY nodes in the graph, use one of these methods:

" " SORT

This box contains a list of colors. To change the color of SORT nodes in the graph, use one of these methods:

" " RQUERY

This box contains a list of colors. To change the color of RQUERY nodes in the graph, use one of these methods:

" " EISCAN

This box contains a list of colors. To change the color of EISCAN nodes in the graph, use one of these methods:



Update page

Color of Operator nodes:

" " DELETE
" " INSERT
" " UPDATE

" " DELETE

This box contains a list of colors. To change the color of DELETE nodes in the graph, use one of these methods:

" " INSERT

This box contains a list of colors. To change the color of INSERT nodes in the graph, use one of these methods:

" " UPDATE

This box contains a list of colors. To change the color of UPDATE nodes in the graph, use one of these methods:



Miscellaneous page

Color of Operator nodes:

" " UNION
" " UNIQUE
" " RETURN
" " TEMP

" " UNION

This box contains a list of colors. To change the color of UNION nodes in the graph, use one of these methods:

" " UNIQUE

This box contains a list of colors. To change the color of UNIQUE nodes in the graph, use one of these methods:

" " RETURN

This box contains a list of colors. To change the color of RETURN nodes in the graph, use one of these methods:

" " TEMP

This box contains a list of colors. To change the color of TEMP nodes in the graph, use one of these methods: