Visual Explain Diagram tool for Oracle, DB2 and Microsoft SQL Server

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

Getting Started

Installation

JDBC Drivers

Oracle

II.

DB2 UDB

III.	SQL Server

IV.	Sybase ASE

V.	Sybase Anywhere

VI.

Informix

VII.	PostgreSQL

VIII.

MySQL

Character sets

Registering Servers

MSDE 2000

II.	SQL Express 2005

III.	PostgreSQL SSL

Application

I.	Browser & Scripting

II.	Visual Editing

III.	SQL History

IV.	Shortcut Toolbar

Options

VI.

Settings

Query Window

Basics

II.	Shortcut Keys

III.

Toolbar

IV.	Server Side Comments

V.	SQL Automation

VI.	Variable Binding

VII.

Results

VIII.

Save Results

IX.	Auto-completion

X.	SQL Formatter

XI.	Permissions

XII.	Parameterized

Visual Explain Plan

Basics

II.	Explain Plan

III.	Explain Diagram

IV.	Whiteboard

Procedure Editor

Tools

I.	Table Data Editor

II.	Script Generator

III.	ER Diagram

IV.	Query Builder

V.	Import Tool

VI.	Export Tool

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

The Visual Explain Diagram offers a graphical illustration of an explain plan's results. The operations are rendered as a tree of nodes, with the most significant elements colored according to the percentage cost relative to the entire statement.

Use this tool to quickly identify areas of your SQL statements which may require tuning.

To save the diagram as an image (JPG or PNG), click Save Image As
To print a hard-copy of the diagram, click Print
To highlight the critical path, click Color Critical Path
To highlight the critical node, click Color Critical Node
To highlight the critical operation, click Color Critical Operation

Home • Screenshots • Downloads • Documentation • Support • Licensing