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

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-15
I
Histogram tables (continued)
examples of 10-74
HISTINTS 10-73
HISTOGRM 10-72
maintaining 10-69
purpose of 10-68
UPDATE STATISTICS use of 2-246
Histograms
clearing 2-246, 2-252
controls 10-40
generating 2-245
HISTOGRAMS metadata table 10-70
HISTOGRAM_INTERVALS metadata
table 10-71
HISTOGRM metadata table 10-72
HISTORY command
examples of 4-31
syntax diagram of 4-31
HIST_NO_STATS_REFRESH_INTERVAL
default 10-42
HIST_NO_STATS_ROWCOUNT
default 10-42
HIST_NO_STATS_UEC default 10-42
HIST_PREFETCH default 10-42
HIST_ROWCOUNT_REQUIRING_STATS
default 10-43
HIST_SAME_TABLE_PRED_REDUCTION
default 10-43
HIST_SCRATCH_VOL default 10-43
HIST_SECURITY_WARNINGS
default 10-43
Host variable arrays, INSERT
statement 2-152
Host variables, INSERT statement 2-155
HOUR function
examples of 9-64
syntax diagram of 9-64
I
Identifiers 6-54
ID, authorization 1-5
IF statement
examples of 3-63, 3-64
syntax diagram of 3-62
import utility 5-20
IN predicate
examples of 6-95
logical equivalent using ANY 6-94
operand requirements 6-94
syntax diagram of 6-93
Index keys 6-60
Indexes
ALTER INDEX statement 2-7
CREATE INDEX statement 2-54
description of 6-57
POPULATE INDEX utility 5-69
populating 2-59
INDEXJOIN 2-40
INDEX_ELIMINATION_LEVEL
default 10-55
INFO DEFINE command
examples of 4-32
syntax diagram of 4-32
INFO operation 5-36
INITIALIZE SQL statement
authorization and availability
requirements 2-148
examples of 2-148
purpose of 2-148
syntax diagram of 2-148
INSERT access privilege 2-141, 2-170
INSERT function
examples of 9-65
syntax diagram of 9-65
INSERT statement
access options 2-153
compatible data types 2-156
considerations 2-153
DEFAULT values 2-153
limits 2-153
lock modes 2-153