SQL/MX 2.x Reference Manual (H06.04+)

Index
HP NonStop SQL/MX Reference Manual—540440-003
Index-31
S
Statistics (continued)
syntax diagram 4-22
HISINTS SQL/MP table 10-75
Histogram attributes in
SYSTEM_DEFAULTS table 10-41
HISTOGRAMS_nodename table 10-72
HISTOGRAM_INTERVALS table 10-73
HISTOGRM table 10-74
LS command 4-36
query cache 4-18
query plan 4-20
QUERYCACHE function 9-108
QUERYCACHEENTRIES
function 9-112
SET STATISTICS command 4-53
SQL/MP histogram tables 10-69
stored in PARTITIONS table 10-20
UPDATE STATISTICS statement
considerations 2-243
examples of 2-246
syntax diagram 2-239
STDDEV function
DISTINCT clause within 9-142
examples of 9-143
statistical definition of 9-142
syntax diagram of 9-142
STORE BY clause, syntax description 7-22
Stored procedure statements
CALL 2-27
CREATE PROCEDURE 2-59
DROP PROCEDURE 2-120
Stored text
reserved words B-1
SQL/MP restrictions 1-30
Stream timeout
dynamic, SET TABLE TIMEOUT
statement setting 2-214
static
CONTROL QUERY DEFAULT
statement setting 2-33
Stream timeout (continued)
SYSTEM_DEFAULTS table 10-67
STREAM_TIMEOUT default 10-67
String literals 6-60
String value expression
examples of 6-38
syntax diagram of 6-37
struct 3-66
Subquery
correlated 6-88, 6-107
description of 6-105
inner query 6-106
outer query 6-106
outer reference 6-107
row
BETWEEN predicate 6-82
comparison predicate 6-84
IN predicate 6-90
NULL predicate 6-95
quantified comparison
predicate 6-97
scalar
BETWEEN predicate 6-82
comparison predicate 6-84
DELETE statement 2-111, 2-229
IN predicate 6-90
NULL predicate 6-95
quantified comparison
predicate 6-97
UPDATE statement 2-228
table 6-90
SUBSTRING function
examples of 9-146
operand requirements 9-145
syntax diagram of 9-145
SUM function
DISTINCT clause within 9-147
examples of 9-148
syntax diagram of 9-147