SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-29
S
SQL/MP aliases
ALTER SQLMP ALIAS statement 2-9
catalogs 10-48
CREATE SQLMP ALIAS
statement 2-71
description of 6-108
DROP SQLMP ALIAS statement 2-128
OBJECTS table 6-14
schemas 6-104
SQL/MP catalogs 6-2
SQL/MP considerations
access options 1-28
catalogs 6-2
collations 1-30
datetime literals data
inserting 6-66
selecting 6-26
embedded statements 3-1
INTERVAL data
inserting 6-71
selecting 6-32
NCHAR data
inserting 6-64, 6-65
selecting 6-23
reserved words 1-24, B-1
stored text 1-29
views 1-28
SQL/MP objects, define names 6-13
SQL/MX catalogs 6-2
SQL/MX data types 2-63
SQL/MX extensions E-6
reserved words B-1
statements 1-31
SQRT function
examples of 9-146
syntax diagram of 9-146
STABLE access
description of 1-6
locking 10-45
SELECT statement 2-193
STABLE access (continued)
SQL/MP 1-7, 1-28
Standards
ANSI conformance 1-31
ANSI SQL E-1
character set support E-7
ISO E-2
SQL/MX extensions E-6
Statement atomicity
automatic 1-11
control query defaults 10-62
description of 1-11
explain token 4-17
implicit abort 1-12
Statements, SQL
ANSI compliant 1-31
interruption of 1-4
SQL/MX extensions 1-32
Statistics
clearing 2-246
DISPLAY STATISTICS command
example of 2-165, 4-23
syntax diagram 4-22
HISINTS SQL/MP table 10-73
Histogram attributes in
SYSTEM_DEFAULTS table 10-40
HISTOGRAMS_nodename table 10-70
HISTOGRAM_INTERVALS table 10-71
HISTOGRM table 10-72
LS command 4-36
query cache 4-18
query plan 4-20
QUERYCACHE function 9-109
QUERYCACHEENTRIES
function 9-113
SET STATISTICS command 4-53
SQL/MP histogram tables 10-67
stored in PARTITIONS table 10-19
UPDATE STATISTICS statement
considerations 2-249