SQL/MP Query Guide

Analyzing Query Performance
HP NonStop SQL/MP Query Guide—524488-003
6-85
Second Formulation
---------------------------------------------------------------------------
Plan step 2
Characteristic : Executes once before plan step 1
---------------------------------------------------------------------------
Operation 2.0 : Scan
Table : \SQL1.$DATA8.SALES.PARTS
with correlation name P
Access type : Record locks, stable access
Lock mode : Chosen by the system
Column processing : Requires retrieval of 1 out of 4 columns
Access path 1 : Primary, unique
SBB for reads : Not used
Begin key pred. : P.PARTNUM = 5100
End key pred. : P.PARTNUM = 5100
Index selectivity : Expect to examine 3.5714% of rows from table
Index pred. : None
Base table pred. : None
Executor pred. : None
Executor aggr. : Computed for each group
AVG ( QTY_AVAILABLE )
Table selectivity : Expect to select 3.5714% of rows from table
Expected row count: 1 row after the scan
Operation cost : 1
Total cost : 4
Example 6-53. EXPLAIN Plan for QUERY2 (page2of2)