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

Index
HP NonStop SQL/MX Reference Manual—544517-008
Index-16
I
Histograms
clearing 2-264, 2-271
controls 10-43
generating 2-263
HISTOGRAMS metadata table 10-77
HISTOGRAM_INTERVALS metadata
table 10-78
HISTOGRM metadata table 10-79
HISTORY command
examples of 4-31, 4-33
syntax diagram of 4-31, 4-33
HIST_DEFAULT_SEL_FOR_LIKE_WILDC
ARD default 10-44
HIST_DEFAULT_SEL_FOR_PRED_RANG
E default 10-44
HIST_JOIN_CARD_LOWBOUND
default 10-44
HIST_NO_STATS_REFRESH_INTERVAL
default 10-45
HIST_NO_STATS_ROWCOUNT
default 10-45
HIST_NO_STATS_UEC default 10-45
HIST_PREFETCH default 10-45
HIST_ROWCOUNT_REQUIRING_STATS
default 10-46
HIST_SAME_TABLE_PRED_REDUCTION
default 10-46
HIST_SCRATCH_VOL default 10-46
HIST_SECURITY_WARNINGS
default 10-47
Host variable arrays, INSERT
statement 2-171
Host variables, INSERT statement 2-174
HOUR function
examples of 9-69
syntax diagram of 9-69
I
Identifiers 6-53
ID, authorization 1-5
IF statement
examples of 3-62, 3-63
IF statement (continued)
syntax diagram of 3-61
import utility 5-27
IN predicate
examples of 6-93
limits C-1
logical equivalent using ANY 6-92
operand requirements 6-92
syntax diagram of 6-91
Index keys 6-59
Indexes
ALTER INDEX statement 2-7
CREATE INDEX statement 2-56
description of 6-56
limits C-1
POPULATE INDEX utility 5-108
populating 2-61
INDEXJOIN 2-42
INDEX_ELIMINATION_LEVEL
default 10-59
INFER_CHARSET default 10-60
INFO DEFINE command
examples of 4-34
syntax diagram of 4-34
INFO operation 5-61
INITIALIZE SQL statement
authorization and availability
requirements 2-167
examples of 2-167
purpose of 2-167
syntax diagram of 2-167
INSERT access privilege 2-161, 2-189
INSERT function
examples of 9-70
syntax diagram of 9-70
INSERT statement
access options 2-172
compatible data types 2-174
considerations 2-172
DEFAULT values 2-172