SQL Programming Manual for Pascal

Program Compilation and Execution
HP NonStop SQL Programming Manual for Pascal—528614-001
5-17
Using the EXPLAIN Utility
Using the EXPLAIN Utility
The EXPLAIN utility generates reports about the execution plans used for each SQL
statement. You can use EXPLAIN reports to determine the database tables and
indexes used by program. You can also determine whether creating other indexes or
Figure 5-3. Sample SQL Compiler Listing
Copyright Tandem Computers Incorporated 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1990, 1991
BINDER - OBJECT FILE BINDER - T9621C20 - (15FEB89) SYSTEM \SYS
TIMESTAMP 1989-10-09 09:51:18
Object file \SYS.$VOL1.PROGS.PTESTO
SQL - Source File = $VOL1.PROGS.PTEST
SQL - PROGRAM FILE = \SYS.$VOL1.PROGS.PTESTO
SQL - PROGRAM CATALOG = \SYS.$VOL1.INVENT
SQL - DEFAULT CATALOG = \SYS.$VOL1.INVENT
COPYRIGHT TANDEM COMPUTERS INCORPORATED 1987, 1988, 1989, 1990, 1991
Options : NOFORCE, OBJECT, CURRENTDEFINES, RECOMPILE, RECOMPILEALL, NOEXPLAIN
SQL Compiler - T9095C30 - (15JUN91)
DATE - TIME : 10/09/89 - 09:51:18
FREE RESOURCES
198
173
FREE RESOURCES
* * * Statistics: Estimated cost: 1
140
INSERT INTO =PARTLOC
137
VALUES ( :PARTLOC_REC.LOC_CODE,
138
:PARTLOC_REC.PARTNUM,
139
:PARTLOC_REC.QTY_ON_HAND )
Code pages10
Primary data words28
Data pages64
Secondary data words22198
Resident code pages
0
Top of stack location in words22226
Heap location: Regular data space
Extended data pages
0
Heap size in pages
20
Binder Errors
0
Binder Warning
1
Code segment
1
SQL **************************************************
SQL - Summary of SQL Compiling
SQL - Number of SQL Statements = 5
SQL - Number of SQL Errors = 0
SQL - Number of SQL Warnings = 0
SQL - Number of other Errors = 0
SQL - Compile Time = 00:00:01.130
SQL - Elapsed Time = 00:01:04.052
SQL - Program file is \SYS.$VOL1.PROGS.PTESTO
SQL - >>> SQL COMPILATION STORED IN PROGRAM FILE <<<
VST0503.vsd