Manualshelf

SQL/MP Query Guide

ManualsBrandsHP ManualsServerHP NonStop G-Series
291292293294295296297298299300
Analyzing Query Performance
HP NonStop SQL/MP Query Guide—524488-003
6-81
First Formulation
After executing the query, use the DISPLAY STATISTICS command to display the
statistics as shown in Example 6-50 The estimated cost is 50. The ODETAIL table is
scanned once. The PARTS table is scanned twice.
By examining the EXPLAIN plan shown in Example 6-51 on page 6-82, you can better
understand how the cost is determined.
Example 6-50. DISPLAY STATISTICS Output for QUERY1
Estimated Cost 50
Start Time 95/09/11 09:08:13.871517
End Time 95/09/11 09:08:14.546697
Elapsed Time 00:00:00.675180
SQL Execution Time 00:00:00.229874
Records Records Disk Message Message Lock
Table Name Accessed Used Reads Count Bytes
\SQL1.$DATA8.SALES.ODETAIL
72 4 2 3 490
\SQL1.$DATA8.SALES.PARTS
112 112 2 8 3792
\SQL1.$DATA8.SALES.PARTS
3136 112 2 336 90048