SQL/MP Query Guide

Index
HP NonStop SQL/MP Query Guide—524488-003
Index-12
T
Subquery (continued)
evaluating 3-51
noncorrelated 1-29, 3-53
nonquantified 1-29
quantified 1-29
SUBSTRING function
data types for results 1-16
empty string results 1-17
errors 1-17
EXPLAIN plan for 6-39
in a query 1-16
null results 1-17
to extract part of a string 1-15
SUM function 1-41
T
Tables
controlling opening of 4-29
cost of accessing 5-12
full scans of, avoiding 3-54, 4-4
inner 3-25
joining 1-51
outer 3-25
scanning 4-4
scans and EXPLAIN 6-13
selectivity of 5-1, 5-7
TIME data type 1-21
Timeout of processes 4-31
TIMESTAMP data type 1-21
TRIM function 1-19
U
UEC (unique entry count) 5-2
Unassigned ESPs, processor assignment
and 2-5
UNION ALL, using to avoid sorts 1-61
UNION clause
description of 1-61
GROUP BY clause and 1-64
UNION clause (continued)
HAVING clause and 1-64
ORDER BY clause and 1-63
using 3-54
Unique entry count (UEC) 5-2
UPDATE statement, EXPLAIN plan
for 6-77
UPDATE STATISTICS statement 4-2
UPS (User Process Sort) 3-56
UPSHIFT function 1-18
User process sort (UPS) 3-56
V
Views, controlling opening of 4-29
Virtual sequential block buffering (VSBB)
See VSBB
VLM option for FastSort 4-32
VSBB (Virtual sequential block buffering)
description of 4-21, 4-24
how the optimizer chooses 4-21
W
WHERE clause
in join operations 1-59, 1-60
of SELECT statement 1-9
search conditions and 1-8
Wild-card characters 1-34