SQL/MP Query Guide

Index
HP NonStop SQL/MP Query Guide—524488-003
Index-5
G
FROM clause of SELECT statement 1-2
Full table scan, avoiding 3-54, 4-4
Functions
aggregate 1-41
AVG 1-41
COUNT 1-41
CURRENT 1-25
DATEFORMAT 1-26
date-time 1-24
DAYOFWEEK 1-26
EXTEND 1-27
JULIANTIMESTAMP 1-27
MAX 1-41
MIN 1-41
SUBSTRING 1-15
SUM 1-41
G
Granularity 4-19
GROUP BY clause
efficient use of 3-47, 3-54
EXPLAIN plan for 6-26, 6-28
MDAM and 3-49
of SELECT statement 1-4, 1-7
parallel plans and 3-49
selectivity 5-10
serial plans and 3-48
UNION operation and 1-64
with DISTINCT 3-58
with ORDER BY 3-57
Grouping rows for aggregate functions 1-7
H
Halloween problem 4-10
Hash join method
build phase 3-30
description of 3-30
EXPLAIN plan for 6-49
hybrid 3-31
Hash join method (continued)
matching partitions 3-33
parallel 3-32
probe phase 3-30
repartitioned parallel 3-33
simple sequential 3-31
HAVING clause
search conditions and 1-9
UNION operation and 1-64
Host variables
initializing in cursor 1-12
with SELECT statement 1-10
I
IN EXCLUSIVE MODE option 4-19
IN predicate
description of 1-36
performance implication of 3-7
transformation of 3-7
IN SHARE MODE option 4-19
Index
access 4-5, 4-6
availability of 4-7
base-table access 4-6
controlling opening of 4-29
cost of 5-16
length 4-5
performance improvement 3-22
predicate 3-13
selectivity 5-1, 5-6
Index-only access
description of 4-5, 4-6
EXPLAIN plan for 6-19
using 4-9
Inner join operation 1-53, 1-54, 6-68
Inner query
See Subquery
Inner table 3-25