Orig Nodes
Orig nodes are nodes with no children. When reading a QEP, you should first find the orig nodes of the tree. Orig nodes are the most common type of QEP node.
Orig nodes describe a base table or secondary index being accessed from the query. This type of node displays the following:
• Table or index name
• Storage structure
• Total number of pages and tuples
For a description of each of these parts of the display, see
Information on a QEP (see page
Information on a QEP).