68 lines
4.7 KiB
HTML
68 lines
4.7 KiB
HTML
|
<?xml version="1.0" encoding="UTF-8"?>
|
||
|
|
<!DOCTYPE html
|
||
|
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
||
|
|
<html lang="en-us" xml:lang="en-us">
|
||
|
|
<head>
|
||
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
|
|
<meta name="security" content="public" />
|
||
|
|
<meta name="Robots" content="index,follow" />
|
||
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
||
|
|
<meta name="DC.Type" content="reference" />
|
||
|
|
<meta name="DC.Title" content="View the implementation of your queries with Visual Explain" />
|
||
|
|
<meta name="abstract" content="You can use the Visual Explain tool with iSeries Navigator to create a query graph that graphically displays the implementation of an SQL statement. You can use this tool to see information about both static and dynamic SQL statements. Visual Explain supports the following types of SQL statements: SELECT, INSERT, UPDATE, and DELETE." />
|
||
|
|
<meta name="description" content="You can use the Visual Explain tool with iSeries Navigator to create a query graph that graphically displays the implementation of an SQL statement. You can use this tool to see information about both static and dynamic SQL statements. Visual Explain supports the following types of SQL statements: SELECT, INSERT, UPDATE, and DELETE." />
|
||
|
|
<meta name="DC.subject" content="Visual Explain, definitions, Visual Explain" />
|
||
|
|
<meta name="keywords" content="Visual Explain, definitions, Visual Explain" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="queryopt.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqstartve.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzajqovrve.htm" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="visexpl" />
|
||
|
|
<meta name="DC.Language" content="en-us" />
|
||
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
||
|
|
<!-- US Government Users Restricted Rights -->
|
||
|
|
<!-- Use, duplication or disclosure restricted by -->
|
||
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
||
|
|
<title>View the implementation of your queries with Visual Explain</title>
|
||
|
|
</head>
|
||
|
|
<body id="visexpl"><a name="visexpl"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">View the implementation of your queries with Visual Explain</h1>
|
||
|
|
<div><p>You can use the <strong>Visual Explain</strong> tool with iSeries™ Navigator
|
||
|
|
to create a query graph that graphically displays the implementation of an
|
||
|
|
SQL statement. You can use this tool to see information about both static
|
||
|
|
and dynamic SQL statements. Visual Explain supports the following types of
|
||
|
|
SQL statements: SELECT, INSERT, UPDATE, and DELETE.</p>
|
||
|
|
<div class="section"><p>Queries are displayed using a graph with a series of icons that
|
||
|
|
represent different operations that occur during implementation. This graph
|
||
|
|
is displayed in the main window. In the lower portion of the pane, the SQL
|
||
|
|
statement that the graph is based on is displayed. If Visual explain is started
|
||
|
|
from Run SQL Scripts, you can view the debug messages issued by the optimizer
|
||
|
|
by clicking the <span class="uicontrol">Optimizer messages</span> tab. The Query attributes
|
||
|
|
are displayed in the right pane.</p>
|
||
|
|
<p>Visual Explain can be used to graphically
|
||
|
|
display the implementations of queries stored in the detailed SQL performance
|
||
|
|
monitor. However, it does not work with tables resulting from the memory-resident
|
||
|
|
monitor.</p>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajqstartve.htm">Starting Visual Explain</a></strong><br />
|
||
|
|
There are two ways to invoke the Visual Explain tool. The first,
|
||
|
|
and most common, is through iSeries Navigator. The second is through the Visual
|
||
|
|
Explain (QQQVEXPL) API.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzajqovrve.htm">Overview of information available from Visual Explain</a></strong><br />
|
||
|
|
You can use Visual Explain to view many types of information.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="queryopt.htm" title="Query optimization is an iterative process. You can gather performance information about your queries and control the processing of your queries.">Optimizing query performance using query optimization tools</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|