SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-31
S
ALTER SQLMP ALIAS statement 2-17
catalogs 10-61
CREATE SQLMP ALIAS
statement 2-104
description of 6-112
DROP SQLMP ALIAS statement 2-188
OBJECTS table 6-15
schemas 6-107
SQL/MP catalogs 6-3
SQL/MP considerations
access options 1-32
catalogs 6-3
collations 1-33
datetime literals data
inserting 6-69
selecting 6-28
embedded statements 3-1
INTERVAL data
inserting 6-73
selecting 6-33
NCHAR data
inserting 6-66, 6-67
selecting 6-25
reserved words 1-27, B-1
stored text 1-32
views 1-32
SQL/MP objects, define names 6-14
SQL/MX catalogs 6-3
SQL/MX data types, and SPJ
methods 2-90
SQL/MX extensions E-6
reserved words B-1
statements 1-34
SQRT function
examples of 8-170
syntax diagram of 8-170
STABLE access
description of 1-8
locking 10-57
SELECT statement 2-345
SQL/MP 1-8, 1-32
Standards
ANSI conformance 1-34
ANSI SQL E-1
character set support E-7
ISO E-2
SQL/MX extensions E-6
Statement atomicity
automatic 1-14
control query defaults 10-78
description of 1-14
implicit abort 1-14
Statements, SQL
ANSI compliant 1-34
interruption of 1-5
SQL/MX extensions 1-35
Statistics
clearing 2-403
DISPLAY STATISTICS command
example of 2-301, 4-24
syntax diagram 4-23
HISINTS SQL/MP table 10-91
Histogram attributes in
SYSTEM_DEFAULTS table 10-52
HISTOGRAMS_nodename table 10-87
HISTOGRAM_INTERVALS table 10-89
HISTOGRM table 10-90
LS command 4-51
query cache 4-19
query plan 4-21
QUERYCACHE function 8-134
QUERYCACHEENTRIES
function 8-138
SET STATISTICS command 4-69
SQL/MP histogram tables 10-84
stored in PARTITIONS table 10-24
UPDATE STATISTICS statement
considerations 2-406
examples of 2-410
syntax diagram 2-402