SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-17
P
PHYSVOL option
CREATE CATALOG statement 5-7
CREATE INDEX example 5-46
creating indexes 5-45
creating partitions 5-33
creating tables 5-18
system catalog 2-5
PINs 2-13
Planning database and data dictionary 1-3,
3-1
Plan, access 10-6, 10-12
Plan, query execution 10-6, 10-12
PRIMARY KEY clause 3-2, 3-6
Primary keys
See also User-defined primary key
access paths 3-2, 5-42
description 3-2, 5-11
entry-sequenced files 3-9, 5-14
generic locks 14-21
indexes 5-42
logical 3-2
null values 5-27
performance issues 3-4
physical 3-2, 3-6
system defined 3-3, 5-11
user-defined 3-2
Privileged operations, SQLCI2 process A-1
Process file segment (PFS)
changing size limit 14-20
DEFINEs 10-30
description 14-19
file system double buffering 14-19
Processor usage
controlling, examples 12-12
determining, _SQL_CMP_CPUS
DEFINE 12-13
limiting 12-11
SMF 12-13
Process, disk 3-2
Production database 1-1, 14-12
Program downtime, preventing 10-25
Programs
adding columns, effect 7-10
backing up 9-34
binding 10-1
constraints 14-23
DEFINEs 10-32
executing
access path changes 10-9
automatic recompilation 10-7
cost 13-9
invalidating changes 10-9
integrating new columns 7-11
invalidation 10-1
maintaining for best performance 10-12
manipulating 10-38
moving 9-14, 10-39, 10-44
object 10-7
recompilation 10-7
registering 10-7, 10-40
renaming 10-38
restarting 10-8
restoring 11-6
SENSITIVE flag 10-6
SQLSA 13-4
statistics for execution 13-9
status information 13-4
upgrading 2-12
VALID flag 10-6
validity 10-5
VERIFY utility 10-4
PROGRAMS catalog table
querying 10-5
RECOMPILETIME value 10-4
securing 5-7, 7-15
VALID flag
automatic compilation 10-6
description 10-4/10-5
invalidation 10-16