NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-37
Q
PROGRAMS catalog table
and program invalidation P-28
, P-29
description of P-30
PROGRAM, parameter for FastSort Z-4
Prompts S-61
Protection views
AUDIT file attribute A-69
description of P-31, V-9
limit per table L-12
similarity S-56
PROTECTION, in VIEWS table V-9
PS Text Edit T-3
PUP utility U-18
PUP (Peripheral Utility Program) C-128,
C-129
Purge
date and time, changing A-30
objects D-60
Purge access S-14
PURGE command
and TMF P-33
, P-34
description of P-31
LISTALL option P-33
SHADOWSONLY option P-33
PURGEDATA command
and TMF P-36
, P-37
description of P-36
LISTALL option P-37
Q
Qualified column names C-41
Qualified fileset list Q-1
Quantified predicate Q-5
QUANTIFIED PREDICATE comparison
predicate Q-6
Queries
inner J-1
join J-1
outer J-1
Query execution plans P-21
Query optimization
CONTROL EXECUTOR
directive C-69
CONTROL QUERY directive C-70
equijoin for parallel execution C-69
parallel processing C-68, C-69
using current statistics S-76
Query processing
getting partial results C-82
table reference limit L-11
Quotation marks within string literals S-79
R
Random access block size B-5
Range of values, selecting B-3
Read access S-14
READ COMMITTED S-70
READ operations, buffered C-77
READ UNCOMMITTED S-70
Reading
data S-17
row F-3
REAL data syntax D-5
RECIN option, LOAD command L-24
RECLENGTH file attribute R-1
Recompilation
automatic P-28
explicit P-28
RECOMPILEMODE, in PROGRAMS
table P-31
RECOMPILETIME, in PROGRAMS
table P-30
Record definition
invoking I-26
Record descriptions
catalog tables B-1
tables and views I-24
Record length