SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-16
H
example of 4-35
syntax diagram of 4-35
GET VERSION OF MODULE command
example of 4-41
syntax diagram of 4-41
GET VERSION OF Object command
example of 4-40
syntax diagram of 4-40
GET VERSION OF PROCEDURE
command
example of 4-42
syntax diagram of 4-42
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
GIVECATALOG 2-195
GOAWAY operation 5-31
GRANT EXECUTE statement
authorization and availability
requirements 2-204
examples of 2-205
security 2-204
syntax diagram of 2-203
GRANT SECURITY_ADMIN 2-206
GRANT statement
authorization and availability
requirements 2-200
examples of 2-201
security 2-200
syntax diagram of 2-198
GTACL command
examples of 4-32
syntax of 4-32
Guardian name resolution 10-62
Guardian physical name 6-13
H
Hash groupby, scratch files 10-76
Hash join
performance 2-57
scratch files 10-76
Hash partitioning
description of 6-83
MODIFY utility 5-80
HashPartFunc function
examples of 9-74
syntax diagram of 9-74
HISTINTS metadata table 10-90
Histogram tables
creating 10-84
dropping 10-84
examples of 10-91
HISTINTS 10-90
HISTOGRM 10-89
maintaining 10-85
purpose of 10-84
UPDATE STATISTICS use of 2-311
Histograms
clearing 2-311
, 2-318
controls 10-52
generating 2-310
HISTOGRAMS metadata table 10-86
HISTOGRAM_INTERVALS metadata
table 10-88
HISTOGRM metadata table 10-89
HISTORY command
examples of 4-32, 4-44
syntax diagram of 4-32, 4-44
HIST_DEFAULT_SEL_FOR_LIKE_WILDC
ARD default 10-53