SQL Programming Manual for TAL

ManualsBrandsHP ManualsServerHP NonStop G-Series

141

142

143

144

145

146

147

148

149

150

Program Compilation and Execution

HP NonStop SQL Programming Manual for TAL—527887-001

5-21

Using the EXPLAIN Utility

Figure 5-6. EXPLAIN Utility Report

*************************************************************

SQL Compiler - T9095C30 - (01NOV91)

DATE - TIME : 11/15/91 - 09:18:15

Options : NOFORCE, NOOBJECT, STOREDDEFINES, RECOMPILE,

RECOMPILEALL, EXPLAIN PLAN DEFINES, OBEYFORM

SQL - PROGRAM FILE = \SYS1.$VOL1.PROGS.OXPLAIN

SQL - PROGRAM CATALOG = \SYS1.$VOL1.INVENT

SQL - DEFAULT CATALOG = \SYS1.$VOL1.INVENT

SQL - Source File = \SYS1.$VOL1.PROGS.XPLAIN

DECLARE GET_EMP_BY_AVG_SAL_CURSOR CURSOR FOR

SELECT EMPNUM, FIRST_NAME, LAST_NAME, SALARY

WHERE SALARY >

FROM =EMPLOYEE

BROWSE ACCESS

AND DEPTNUM = :select_dept

BROWSE ACCESS )

FROM =EMPLOYEE

( SELECT AVG (SALARY)

-----------------------------------------------------------------------------------------

QUERY PLAN : 1

STATEMENT TYPE : SELECT

. . .

109

CONTROL EXECUTOR PARALLEL EXECUTION ON

*************************************************************

SQL

- Summary of SQL Compiling

SQL

- Number of SQL Statements = 3

- Number of SQL Errors = 0

- Number of SQL Warnings = 0

- Number of other Errors = 0

- Compile Time = 00:00:01.887

- Elapsed Time = 00:00:11.656

- Program file is \SYS1.$VOL1.PROGS.OXPLAIN

- >> PROGRAM FILE UNCHANGED BECAUSE OF NOOBJECT OPTION <<

*************************************************************

-----------------------------------------------------------------------------------------

DEFINES MAPPING

ALTER DEFINE =_DEFAULTS, VOLUME \SYS1.$VOL1.PROGS

ALTER DEFINE =_DEFAULTS, CATALOG \SYS1.$VOL1.INVENT

ADD DEFINE =EMPLOYEE, FILE \SYS1.$VOL1.PERSNL.EMPLOYEE

ADD DEFINE =CUSTOMER, FILE \SYS1.$VOL1.SALES.CUSTOMER

ADD DEFINE =ORDERS, FILE \SYS1.$VOL1.SALES.ORDERS

VST0506.vsd