12. Using the Query Optimizer : Types of Nodes in a QEP : Non-Join Nodes in a QEP : Orig Nodes
 
Share this page                  
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).