SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-14
N
Measure product (continued)
ELAPSED-RECOMPILE-TIME
counter 13-9
ESCALATION counters 13-10, 13-11
FILE entity 13-5, 13-8, 13-10
index creation 7-4
LOCK-WAITS counters 13-10, 13-11
OPENS counter 13-9
RECOMPILES counter 13-9
RECORDS-ACCESSED
counters 13-9, 13-10
RECORDS-USED counter 13-10
SORTS counter 13-10
SQLPROC entity 13-5
SQLSTMT entity 13-5
SQL-NEWPROCESS counter 13-8
SQL-OBJ-RECOMPILE-TIME
counter 13-8
statistics reports 13-6
TIMEOUTS counters 13-10, 13-11
Measuring performance 13-1/13-11
Memory, system requirement 2-2
Merging partitions 7-20, 7-23
Migrating to a new SQL/MP version 2-10
MIN function, optimization 3-22
Mirrored disk volumes 2-2, 4-1, 11-33
MOVE option, LOAD utility 8-12
Moving partition boundaries 7-22
Moving partitions 7-20, 9-23
N
Name resolution
CATALOG DEFINE 10-13
cursors 10-14
execution-time 10-13
MAP DEFINE 10-13
subvolume names 10-13
Names
constraint 5-52
DEFINEs for substitution 10-30
Names (continued)
resolution for cursor 10-14
rules for column 5-19
tables, similarity check rules 10-27
National character data types 2-1
NATIONAL CHARACTER VARYING
column, zero-length string 5-27
Networks
distributed databases 12-2, 12-4
environments 12-15
lines 12-6
security 12-4
version issues 2-13
New process statistics 13-8
NO DEFAULT clause 5-26, 7-33
NO RECOMPILE option, UPDATE
STATISTICS statement 14-11
NOAUDITCOMPRESS attribute 5-17
Node
adding 12-15
altering 12-15
D-series features 2-12
names 2-1, 12-3
remote, availability 12-7
removing 12-15
renaming or renumbering 9-32
Nonaudited files
manual resolution of
inconsistency 11-10
restoring 11-10
Nonaudited objects
archiving 4-18
backing up with AUDITED option 9-34
Nonaudited tables, restoring 11-2
NOPURGEUNTIL attribute
altering 7-19
dependent indexes 4-5
similarity check rules 10-28