SQL/MP Query Guide

Index
HP NonStop SQL/MP Query Guide—524488-003
Index-11
S
SELECT statement (continued)
single-row 1-10, 3-60
WHERE clause 1-9
Selectivity
and EXPLAIN plan 6-15
computing
description of 5-2
when a range is used 5-5
when no range is used 5-4
default values for 5-9
definition of 5-1
index 5-6
predicate 5-3
statistics for estimating 5-2
table 5-7
Self join 3-42
Sequential access 4-28
Sequential block buffering (SBB)
See SBB
Sequential cache, EXPLAIN plan and 6-14
Sequential table scan 4-5
SET STATISTICS ON option 6-4
Shared lock 4-19
SHARED mode, LOCK TABLE
statement 4-19
Similarity checking 4-33
Single-row
disk access 4-21, 4-22
SELECT statement 1-10, 3-60
Slack space 4-23
SOME predicate 1-38
Sort merge join method
description of 3-25
EXPLAIN plan for 6-58
Sort operations
cost of 5-14
DISTINCT clause and 3-55
EXPLAIN plan and 6-13
GROUP BY clause and 3-55
logical 3-55
Sort operations (continued)
ORDER BY clause and 3-55
physical 3-56
removing requests for 3-54
specifying indexes to improve
performance of 3-58
UNION clause and 3-55
Sorts, enhancing performance of 4-32
SQL
dynamic 1-1
embedded
SELECT statement in 1-10
using cursors in 1-12
parallel processing 4-13
programmatic
SELECT statement in 1-10
using cursors in 1-12
static 1-1
SQL executor 2-3
Stable access 4-17
Statistics
DISPLAY STATISTICS command 6-3
effect of skewed data on 4-9, 5-2
SET STATISTICS ON option 6-4
UPDATE STATISTICS statement 4-2
updating for tables and columns 4-2
using for better query plan 4-2
String functions 1-15
Strings
determining the length of 1-18
extracting parts of 1-15
removing leading characters from 1-19
removing trailing characters from 1-19
searching for patterns within 1-17
searching without regard for case 1-18
Subquery
compared to join 3-41
correlated 1-29, 5-14
cost of 5-14
description of 1-28