Wiki Books
Search Tips

Easily find issues by searching: #<Issue ID>
Example: #1832

Easily find members by searching in: <username>, <first name> and <last name>.

Example: Search smith, will return results smith and adamsmith
You can use:
- Boolean operators AND, OR and NOT (must be in caps, e.g. oracle AND debugger, debugger NOT oracle)
- Single and multiple character wildcard (e.g. de?ug, debug*)
- Grouping (e.g. ((oracle debugger) AND exception))
- Quoted phrase (e.g. "Oracle Debugger")

#loadingpage {display:none}JavaScript and Cookies must be enabled in order for you to use AquaClusters.here

Aqua Data Studio / nhilam

Follow 827

IDE for Relational Databases

Like 0

DB2 z/OS Visual Explain Plan

Visual Explain is now available for DB2 z/OS versions 9 and higher, giving you the details you need to track down query bottlenecks. The Visual Explain Diagram for DB2 z/OS allows you to click on operations in a flowchart style diagram to view full operation details. Nodes are color-coded to help you identify what has the highest cost. Our Explain Plan Details in the Results Pane list operation details such as JOINs, SORTs, TABLESPACE SCAN and INDEX SCAN costs for quick viewing.

Visual Explain Diagram

View a Visual Explain Diagram of your queries to see where executions bog down.

Explain Plan Details

View detailed statistics of your executed query to track down bottlenecks, including IO cost and CPU cost.

Comments (0) Attachments (12)

This list is empty.

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017