SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-21
S
SMF (continued)
FILEINFO command 6-10
PHYSVOL option 5-33
processor usage 12-13
system catalog 2-5
Sort operations
EXPLAIN utility 14-26
index creation 5-44
performance 14-26
specifying indexes to improve
performance 3-21
Sort programs 2-8
SORTED option 9-21
SORTPROG, FastSort process 14-26
SORTS counter, Measure 13-10
SORT_DEFAULTS DEFINEs 14-26
SOURCEDATE option 9-4
Split partitions
one-way split 7-21
two-way split 7-22
SQL
See also SQL/MP
compiler listing 10-40
executor, behavior after SQL load
time 10-22
load time 10-13
programs
backing up 9-34
file label 10-16
SQL compilation
explicit 10-6
logging 10-5
SQL SENSITIVE flag 10-6
SQLCATALOGS ON option 4-18
SQLCI (SQL Conversational Interface)
DEFINEs 10-30
DUP command 10-40
licensing A-1
query execution plans 10-12
TMF considerations 4-16
SQLCI2
altering security 2-8
description 2-4
licensing A-1
privileged operations A-1
SQL/MP initialization 2-4
ZZSQLCI2 file 2-4, 2-6
SQLCOMP command 10-45
SQLCOMPILE option
RESTORE utility 10-42
RESTORE with CHECK option 10-43
RESTORE with NOREGISTER
option 10-43
restoring database 11-9
restoring programs 11-6
SQLPROC entity
counters 13-8
description 13-5
statistics 13-6
SQLSA (SQL Statistics Area) 13-4
SQLSTMT entity
counters 13-9/13-10
description 13-5
statistics 13-7
SQL-NEWPROCESS counter,
Measure 13-8
SQL-OBJ-RECOMPILE-TIME counter,
Measure 13-8
SQL/MP
audited objects, recovering
purged 11-17
catalog requirements 5-4
compilation
automatic 10-12
CURRENTDEFINES option 10-32
DEFINEs 10-32
description 10-6
elapsed time statistics 13-8
EXPLAIN utility 10-11
gathering statistics 13-6