SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-31
S
Statements, SQL
ANSI compliant 1-32
interruption of 1-5
SQL/MX extensions 1-33
Statistics
clearing 2-264
DISPLAY STATISTICS command
example of 2-184, 4-23
syntax diagram 4-22
HISINTS SQL/MP table 10-80
Histogram attributes in
SYSTEM_DEFAULTS table 10-43
HISTOGRAMS_nodename table 10-77
HISTOGRAM_INTERVALS table 10-78
HISTOGRM table 10-79
LS command 4-40
query cache 4-18
query plan 4-20
QUERYCACHE function 9-112
QUERYCACHEENTRIES
function 9-116
SET STATISTICS command 4-57
SQL/MP histogram tables 10-74
stored in PARTITIONS table 10-20
UPDATE STATISTICS statement
considerations 2-267
examples of 2-271
syntax diagram 2-263
STDDEV function
DISTINCT clause within 9-146
examples of 9-147
statistical definition of 9-146
syntax diagram of 9-146
STORE BY clause, syntax description 7-22
Stored procedure statements
CALL 2-29
CREATE PROCEDURE 2-63
DROP PROCEDURE 2-126
Stored text
reserved words B-1
Stored text (continued)
SQL/MP restrictions 1-30
Stream timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-237
static
CONTROL QUERY DEFAULT
statement setting 2-36
SYSTEM_DEFAULTS table 10-72
STREAM_TIMEOUT default 10-72
String literals 6-61
String value expression
examples of 6-39
syntax diagram of 6-38
struct 3-67
Subquery
correlated 6-89, 6-108
description of 6-106
inner query 6-107
outer query 6-107
outer reference 6-108
row
BETWEEN predicate 6-83
comparison predicate 6-85
IN predicate 6-91
NULL predicate 6-96
quantified comparison
predicate 6-98
scalar
BETWEEN predicate 6-83
comparison predicate 6-85
DELETE statement 2-117, 2-253
IN predicate 6-91
NULL predicate 6-96
quantified comparison
predicate 6-98
UPDATE statement 2-252
table 6-91
SUBSTRING function
examples of 9-150