SQL/MP Query Guide

Analyzing Query Performance
HP NonStop SQL/MP Query Guide—524488-003
6-79
DAY Date-Time Values
DAY Date-Time Values
Example 6-49 on page 6-80 shows DAY(3) expanded to DAY. The query used in this
example is as follows:
INVOKE B2UNL13 ;
Definition of table \SQL1.$DATA5.SQLDOPTS.B2UNL13
Definition current at 09:08:10 - 09/11/95
(
DATE0_N100 DATETIME YEAR TO DAY DEFAULT NULL
, SBIN0_4 SMALLINT DEFAULT SYSTEM NOT NULL
, SDEC0_N100 DECIMAL( 2, 0 ) DEFAULT SYSTEM
, INT0_DTOF6_UNIQ INTERVAL DAY(2) TO FRACTION(6) NO DEFAULT
NOT NULL
, VARCHAR0_N1000 VARCHAR(8) NO DEFAULT
, UDEC1_10P DECIMAL( 9, 0 ) UNSIGNED DEFAULT SYSTEM
NOT NULL
, REAL1_N100 FLOAT(22) DEFAULT SYSTEM
, UBIN1_UNIQ NUMERIC( 9, 0) UNSIGNED NO DEFAULT NOT
NULL
, TS1_NUNIQ DATETIME YEAR TO FRACTION(6) NO DEFAULT
, INT1_YTOM_100 INTERVAL YEAR(2) TO MONTH DEFAULT SYSTEM
NOT NULL
)
EXPLAIN
SELECT
INT0_DTOF6_UNIQ FROM B2UNL13
Example 6-48. EXPLAIN Plan With HOUR Date-Time Values
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Query plan 1
SQL request : Select
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
---------------------------------------------------------------------------
Plan step 1
---------------------------------------------------------------------------
Operation 1.0 : Scan
Table : \SQL1.$DATA5.SQLDOPTS.B2UNS01
with correlation name B2UNS01
Access type : Record locks, stable access
Lock mode : Chosen by the system
Column processing : Requires retrieval of 1 out of 11 columns
Access path 1 : Primary, sequential cache
SBB for reads : Not used
Begin key pred. : None
End key pred. : None
Index selectivity : Expect to examine 100% of rows from table
Index pred. : None
Base table pred. : Will be evaluated by the disk process
INT1_HTOS_1000 = INTERVAL ' 00' HOUR ( 2 ) TO HOUR
Pred. selectivity : Expect to select 0.1% of rows from table
Executor pred. : None
Table selectivity : Expect to select 0.1% of rows from table
Expected row count: 2 rows after the scan
Operation cost : 272
Total cost : 272