SQL/MP Query Guide

Analyzing Query Performance
HP NonStop SQL/MP Query Guide—524488-003
6-78
EXPLAIN Plan With Date-Time Values
EXPLAIN Plan With Date-Time Values
These examples show EXPLAIN plans for an UPDATE operation.
If no end-date-time is provided for an INTERVAL data type and is implied for a start-
date-time, SQL expands the original syntax of the query to show the implied end-date-
time.
HOUR Date-Time Values
Example 6-48 on page 6-79 shows HOUR(2) expanded to HOUR. The query used in
this example is as follows.
INVOKE B2UNS01 ;
Definition of table \SQL1.$DATA5.SQLDOPTS.B2UNS01
Definition current at 09:08:07 - 09/11/95
(
CHAR0_N10 CHAR(2) DEFAULT "AD"
HEADING 'char0_n10 with default ''AD'''
, SBIN0_UNIQ SMALLINT DEFAULT SYSTEM NOT NULL
, SDEC0_N500 DECIMAL( 18, 0 ) DEFAULT SYSTEM
, DATE0_UNIQ DATETIME YEAR TO DAY NO DEFAULT NOT NULL
, INT0_YTOM_NUNIQ INTERVAL YEAR(5) TO MONTH NO DEFAULT
, INT1_HTOS_1000 INTERVAL HOUR(2) TO SECOND DEFAULT SYSTEM
NOT NULL
, DATE1_N4 DATETIME YEAR TO DAY DEFAULT SYSTEM
, REAL1_UNIQ FLOAT(22) NO DEFAULT NOT NULL
, UBIN1_N2 NUMERIC( 4, 0) UNSIGNED NO DEFAULT
, UDEC1_100 DECIMAL( 2, 0 ) UNSIGNED DEFAULT SYSTEM
NOT NULL
)
EXPLAIN
SELECT INT1_HTOS_1000 FROM B2UNS01
WHERE INT1_HTOS_1000 = INTERVAL '0' HOUR(2) ;