SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Reference Manual—640322-001
Index-16
H
GET VERSION OF SCHEMA command
examples of 4-38
syntax diagram of 4-38
GET VERSION OF STATEMENT command
example of 4-43
syntax diagram of 4-43
GET VERSION OF SYSTEM command
example of 4-37
syntax diagram of 4-37
GET VERSION OF SYSTEM SCHEMA
command
example of 4-39
syntax diagram of 4-39
GOAWAY operation 5-26
GRANT EXECUTE statement
authorization and availability
requirements 2-166
examples of 2-166
security 2-166
syntax diagram of 2-165
GRANT statement
authorization and availability
requirements 2-164
examples of 2-164
security 2-164
syntax diagram of 2-162
GTACL command
examples of 4-32
syntax of 4-32
Guardian name resolution 10-59
Guardian physical name 6-13
H
Hash groupby, scratch files 10-73
Hash join
performance 2-40
scratch files 10-73
Hash partitioning
description of 6-83
MODIFY utility 5-80
HashPartFunc function
examples of 9-67
syntax diagram of 9-67
HISTINTS metadata table 10-87
Histogram tables
creating 10-81
dropping 10-81
examples of 10-88
HISTINTS 10-87
HISTOGRM 10-86
maintaining 10-82
purpose of 10-81
UPDATE STATISTICS use of 2-267
Histograms
clearing 2-267, 2-274
controls 10-49
generating 2-266
HISTOGRAMS metadata table 10-83
HISTOGRAM_INTERVALS metadata
table 10-85
HISTOGRM metadata table 10-86
HISTORY command
examples of 4-32, 4-44
syntax diagram of 4-32, 4-44
HIST_DEFAULT_SEL_FOR_LIKE_WILDC
ARD default 10-50
HIST_DEFAULT_SEL_FOR_PRED_RANG
E default 10-50
HIST_JOIN_CARD_LOWBOUND
default 10-50
HIST_NO_STATS_REFRESH_INTERVAL
default 10-51
HIST_NO_STATS_ROWCOUNT
default 10-51
HIST_NO_STATS_UEC default 10-51
HIST_PREFETCH default 10-51
HIST_ROWCOUNT_REQUIRING_STATS
default 10-52
HIST_SAME_TABLE_PRED_REDUCTION
default 10-52
HIST_SCRATCH_VOL default 10-52