SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
E-15
Considerations—EXPLAIN
[ [Key Sequenced] Merge] Join ]
[ (This section appears only for parallel ]
[ plans and is described under "Parallel Execution ]
[ Plan" in the text that follows the figure. ]
[ Typical lines are shown below, though the details ]
[ of section contents vary depending on the plan.) ]
[ ]
[ Each operation is performed in parallel for this step.]
[ ]
[ Each ESP [ from previous step ] will read one of ... ]
[ partition partition partition ... ]
[ The ESPs will be started in the CPU's numbered ]
[ n n n ... ]
[ Each ESP will perform a [ Hybrid ] Hash Join | ]
[ [ [Key Sequenced] Merge Join ... ]
:{Join sequence }
[ Plan Forced :{Join method } forced by user ... ]
:{Join sequence
and join method }
Characteristic :
:{ Insert }
Operation n :{ Scan }
{ Union of plan step n ... n }
Table :
[ Accessed via view : ] (Appears for a protection view)
Access type :
Lock mode :
Column processing :
Access path n :
SBB for reads :
[ Begin key pred. : ]
[ End key pred. : ]
[ MDAM predicate set: ]
[ next set: ]
Index selectivity :
Index pred. :
Base table pred. :
[ Type of [ Update | Delete ] : ]
[ SBB for [ Insert | Update ] : ]
[ Seq Blocksplit : ]
Executor pred. :
[ Executor aggr. : ]
[ Pred. selectivity : ]
[ DP2 aggr. : ]
Table selectivity :
Expected rowcount :
Operation cost :
-----------------------------------------------------------
Operation n : Sort (Appears for sort operations)
Requested :
Sort rows in the :
Purpose :
Sort technique :
Sort type :
UPS workspace :