SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-18
Q
PROGRAMS table 10-16
Protection views
AUDIT attribute 4-15
defining 3-14, 5-38
securing 5-38
similarity check rules 10-28
PUP (Peripheral Utility Program)
description 11-1
DOWN command 11-33
FORMAT command 11-33
LABEL command 11-31, B-1
options 11-31
REMOVE command 11-33
removing SQL objects B-1
RENAME command 11-32
REVIVE command 11-33
UP command 11-33
PURGE command 7-35
PURGE target option 9-4
PURGE utility 7-28, 7-35
PURGEDATA command 8-18
Purging SQL objects 9-33, B-1
Q
Queries
catalog access 6-1
enhancing performance 14-1
ensuring successful execution 14-26
optimization 5-38
parallel execution 14-27
performance 14-27
Query execution plan 10-6, 10-12
Query optimization
current statistics 14-7
partitioning data 5-32
Query performance, buffer size 14-17
R
RDF (Remote Duplicate Database
Facility) 4-1
REAL data type 5-22
Rebuilding CATALOGS table 9-13
RECLENGTH attribute 5-15
Recompilation 10-7, 14-11
RECOMPILE option
CHECK options 10-22
distributed database issues 12-6
UPDATE STATISTICS statement 14-9
RECOMPILES counter, Measure 13-9
Records
length 5-15
RECORDS-ACCESSED
counters 13-10
RECORDS-ACCESSED counters,
Measure 13-9, 13-10
RECORDS-USED counter, Measure 13-10
Recovery
BROKEN flag, resetting 11-11
catalog 11-12, 11-29
crash-open files 11-12
EDIT files 4-24, 5-17
file 4-12, 11-13
manual resolution 11-10
planning 4-1, 4-12, 11-8
RESETBROKEN option 11-11
SQL/MP objects 11-17
TMF subsystem
See TMF subsystem, recovery
tools 11-1
volume 4-12, 11-12, 11-31
Redefinition timestamp
similarity check rules 10-25, 10-26,
10-27
updating 10-16
REDONEEDED flag (FILEINFO) 11-12,
11-13
Registering programs 10-7, 10-40