Documentation: Aqua Data Studio 6.0 - New Features		HTML Documentation download, ZIP: ads-docs.zip (Size: 20MB) / ads-docs-no-shots.zip (Size: 368KB)

Getting Started   Installation   JDBC Drivers   I. Oracle   II. DB2 UDB   III. SQL Server   IV. Sybase ASE   V. Sybase Anywhere   VI. Sybase IQ   VII. Informix   VIII. PostgreSQL   IX. MySQL   Memory Configuration   Character sets   Registering Servers   I. MSDE 2000   II. SQL Express 2005   III. PostgreSQL SSL   Application   I. Browser and Scripting   II. Visual Editing   III. SQL History   IV. Shortcut Toolbar   V. Key Mappings   VI. Custom Keymap Profiles   VII. Options   VIII. Settings   Query Window   I. Basics   II. Toolbar   III. Server Side Comments   IV. SQL Automation   V. Variable Binding   VI. Results   VII. Save Results   VIII. Auto-completion   IX. SQL Formatter   X. Permissions   XI. Parameterized   Editors   I. SQL Editor   II. Text Editor   III. HTML Editor   IV. XML Editor   V. Regular Expressions   Image Viewer   Visual Explain Plan   I. Basics   II. Explain Plan   III. Explain Diagram   IV. Whiteboard   Procedure/Package Editor   Tools   I. Table Data Editor   II. Script Generator   III. ER Diagram   IV. Query Builder   V. Import Tool   VI. Export Tool   VII. Execution Monitor   Difference Tools   I. Schema Diff   II. Tab Diff   III. Directory Diff   IV. File Diff   V. Copy History Diff   Oracle DBA Tools   I. Instance Manager   II. Storage Manager   III. Rollback Manager   IV. Log Manager   V. Security Manager   VI. Session Manager   VII. SGA Manager   VIII. Server Statistics   SQL Server DBA Tools   I. Instance Manager   II. Storage Manager   III. Security Manager   IV. Session Manager   V. SQL Agent Manager   Sybase DBA Tools   I. Instance Manager   II. Storage Manager   III. Security Manager   IV. Session Manager

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.

Home • Screenshots • Downloads • Documentation • Support • Licensing • Contact

Copyright© 2001-2006 AquaFold, Inc. All Rights Reserved