16. Using the Query Optimizer : Query Execution Plans : Text-Only QEP : Modes for Showing Tree Diagrams
 
Share this page                  
Modes for Showing Tree Diagrams
In the SQL Scratchpad window, you can show the tree diagram in one of two modes:
Preview mode gives you a condensed version of the tree, where you can point to a particular node to see its detailed information.
Normal mode displays the detailed information as part of the tree diagram.
Note:   A query that has been modified to include views, integrities, and/or grants, is more involved. The QEP diagram for an involved query (as shown by set qep) can be very wide. On a printout, the diagram can even wrap so that similar levels in the tree appear on different levels. You can find it easier to read such a QEP if you cut and paste the diagram into the correct levels.