SQL/MP Query Guide

Index
HP NonStop SQL/MP Query Guide—524488-003
Index-3
D
D
Data
date-time type 1-21
density 4-30, 5-18
distribution 4-9, 5-2
manipulation statements 1-2
missing, using left join to reveal 1-55
repartitioned 2-5
retrieval
from two tables 1-51
of multiple rows 1-12
ordering the results of 1-5
SELECT statement and 1-2
single row and 1-10
specifying search conditions for 1-8
with cursor 1-12
sparsity 4-30, 5-18
transfer, cost of 5-13
Data distribution, uneven
access 4-9
selectivity 5-2
Database
designing 4-1
searching 1-8
DATEFORMAT function 1-24, 1-26
Date-time
data types 1-21
functions
CONVERTTIMESTAMP 1-25
CURRENT 1-25
DATEFORMAT 1-26
DAYOFWEEK 1-26
description of 1-24
EXTEND 1-27
JULIANTIMESTAMP 1-27
values, EXPLAIN plan for 6-78
DAYOFWEEK function 1-26
Decision Support Systems (DSS) 3-61
DECLARE CURSOR statement 1-12
DELETE statement 1-2
Directives
CONTROL EXECUTOR 4-13
CONTROL QUERY
See CONTROL QUERY directive
CONTROL TABLE
See CONTROL TABLE directive
specifying for optimum
performance 4-1
Disk process 2-3
Disk processor assignment 2-5
DISPLAY STATISTICS command 6-3
DISTINCT clause
EXPLAIN plan for 6-24
of SELECT statement 1-4, 1-6
using 3-54
with GROUP BY 3-58
with ORDER BY 3-58
DML statements 1-2
DSS (Decision Support Systems) 3-61
Duplicate rows, eliminating 1-6
Dynamic SQL 1-1
E
Embedded SQL
SELECT statement in 1-10
using cursors in 1-12
End key 1-32
End-key predicate 3-13
Equality predicate
adding 3-11
using 3-16
Equijoin query 3-25
Equivalence class 3-10
ESP (executor server process) 4-14
Exclusive lock
description of 4-19
granularity 4-19
EXCLUSIVE option, LOCK TABLE
statement 4-19