A QGraph is a useful aid when manually optimizing queries. You enable and disable QGraphs from the Options menu when the Analyze Query window is displayed. When you enable QGraphs, a graph is generated for each SQL statement executed in the Analyze Query window.
| Note: | You cannot enable or disable QGraphs from the other windows of Query Design Center. |
Perform the following steps to generate a QGraph:
-
Display the Analyze Query window, and click QGraphs on the Options menu.
A check mark appears to the left of the command indicating that QGraphs is enabled.
-
Type a valid SQL statement in the text pane.
-
Right-click and click Execute or Prepare.
The text editor Notepad is displayed containing a QGraph for the executed query.
-
If desired, save the QGraph output to a text file.
