Query Window -
Results
Query Analyzer provides 6 different query result options.
 |
| Text
Results -It displays formated text, and the text is
cleared for every query. |
|
| Text History
Results -The Text History is formated text and is appended
to the previous text. |
|
| Oracle
DBMS_OUTPUT -Oracle allows a user to print out messages
from a query, PL/SQL block or stored procedure. ADS will display
this output if it is used by the user. |
|
Grid
Results -Results are displayed in a grid which can be
sorted by clicking on column headings. One grid per statement is
displayed.
more about
Grid Results |
|
Client
Statistics -Displays detailed statistics on the execution
of the statement or script.
Total Processing: This is the amount of time it
takes from the second you click Execute until ADS finishes
displaying all of the results on the screen. This is the Script
Execution time plus the UI time to process the results and display
them.
Client Processing: This is the Total Processing
time minus the server wait time.
Server wait time: Server wait time: This is the
amount of time ADS spends waiting on the server during server-side
methods calls to execute and retrieve results. For example, the
executing of a SELECT query, ADS might wait 3 seconds for the query
to execute on the server (CPU Server Cycles), then another 5
seconds retrieving results (Network Transfer Cycles). So, this is
the best estimate ADS can make on how much time the server spends
executing and sending the data to the client.
Script Parse Time: This is the amount of time it
takes to parse the script. This is usually zero, unless you have a
very large file.
Script Execution Time: This is the total time it
takes from the beginning to the end of the execution of the script.
This is the raw execution time which doesn’t include any time
ADS spends formatting the results to be displayed on the
screen. |
|
| Script
Details - The Script Detail Results lists each statement
executed in a script with detail indicating success, failure and/or
warnings. Double-clicking on an item highlights the associated
lines in the script. |
|
Pivot
Grid - The Pivot Grid presents the results as a set of
pivot tables. One pivot table is displayed per result set.
more about
Pivot Grid Results |
|
| Printing Grid and
Text results - Grid or Text results can be printed out
using a physical or software printer. The printing can be
configured using options presented in the Print dialog such as:
document header and footer, paper size, margins and document
orientation. Printing now provides a popup status dialog that both
shows what page is currently printing and provides the ability to
cancel the print job. |
|
