Query Analyzer provides 5 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 now 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 is displayed per statement.
|
|
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 and
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: This is the amount of time ADS spends waiting on the server on 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 really large file.
Script Execution Time: This is the total time it takes from when it starts executing the
script and it ends execution of the script. So, this is the raw execution and 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 an item highlights the associated lines in the script.
|
|
