Run or Explain a Query
Use the following procedures to run or explain a query.
To run a query
1 From the main window, click Tools>Query.
The Query window appears. For more information, see “Query Window” on page 120.
2 Do one of the following:
i From the Query window, click File>Open.
i From the Query window, click File>Open.ii From the Open dialog box, select the SQL file (*.sql).
iii Click Open to load the file into the note pad area.
3 Click Tools>Run Query.
The output appears in the Query Results window. For more information, see “Results Window” on page 126.
To explain a query
1 From the main window, click Tools>Query.
The Query window appears.
2 Do one of the following:
i From the Query window, click File>Open.
i From the Query window, click File>Open.ii From the Open dialog box, select the SQL file (*.sql).
iii Click Open to load the file into the note pad area.
3 Click Tools>Explain Query.
The Explain appears in the Output from Explain window.