SQL/MP Programming Manual for C

Explicit Program Compilation
HP NonStop SQL/MP Programming Manual for C—429847-008
6-26
SQL Compiler Listings
Using the EXPLAIN Utility
The EXPLAIN utility generates reports about execution plans for each SQL statement.
Use EXPLAIN reports to determine the tables and indexes used by a program and
whether creating other indexes or modifying a query would improve the performance of
the program. The EXPLAIN utility has these report options:

EXPLAIN PLAN Report on page 6-27

EXPLAIN DEFINES Report on page 6-27
133 INSERT INTO =PARTLOC
134 VALUES (:partloc_rec.loc_code,
135 :partloc_rec.partnum,
136 :partloc_rec.qty_on_hand)
*** Statistics: Estimated cost: 1
SQL - SLT Index = 0, Run-Unit = do_add_to_parts
149 INSERT INTO =PARTS
150 VALUES (:parts_rec.partnum,
151 :parts_rec.partdesc,
152 SETSCALE
(:parts_rec.price,2)
153 :parts_rec.qty_available)
*** Statistics: Estimated cost: 2
BINDER - OBJECT FILE BINDER - T9621D30 - (17JUL95) SYSTEM \NEWYORK
Copyright Tandem Computers Incorporated 1982-1995
Object file \NEWYORK.$DISK1.SQLPROG.SQLC
TIMESTAMP 1996-10-04 16:34:56
PAGE 1 10/04/96 - 16:38:23
0 Binder Warnings
0 Binder Errors
PAGE 2 10/04/96 - 16:38:23
SQL **************************************************
SQL - Summary of SQL Compiling
SQL - Number of SQL Statements = 6
SQL - Number of SQL Errors = 0
SQL - Number of SQL Warnings = 0
SQL - Number of other Errors = 0
SQL - Compile Time = 00:00:00.264
SQL - Elapsed Time = 00:00:18.096
SQL - Program file is \NEWYORK.$DISK1.SQLPROG.SQLC
SQL - >>> SQL COMPILATION STORED IN PROGRAM FILE <<<
SQL **************************************************
Example 6-1. Sample SQL Compiler Listing (page 2 of 2)