12. Using the Query Optimizer : Query Execution Plans : Text-Only QEP
 
Share this page                  
Text-Only QEP
In a terminal monitor, a QEP is displayed as a tree, where each node has one or two children:
          Parent
           /     \
        Child    Child
        /
     Parent
     /   \
 Child    Child
Only join nodes have two children. Other nodes have a left child only. Information on node types is provided in Types of Nodes in a QEP.
The tree is read from bottom to top and from left to right, starting with the child nodes at the bottom, going up to the intermediate child nodes, if any, and finally up to the first parent node: