SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-14
Q
Performance (continued)
OLTP 7-39
partitioning data 7-15, 16-14
partitions 9-11
planning for 14-3
queries 16-1
statistics 15-1
testing 9-9
tools for analyzing 15-1
VARCHAR columns 7-22
views 16-14
Periodic backup 5-31
Physical file structure 4-3
Platform.h file 3-9, 3-18
PM_OFFLINE_TRANSACTION_
GRANULARITY 6-4
PM_ONLINE_TRANSACTION_
GRANULARITY 6-4
Post-installation tasks 3-20
POS_LOCATIONS 6-4
POS_NUM_OF_PARTNS 6-4
POS_RAISE_ERROR 6-4
Preinstallation tasks 3-2
PRESERVE_MIN_SCALE 6-4, 6-8
Primary key
and null values 7-29
creating and using 7-12
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION
alternate setting 6-8
ANSI compliance 6-12
description of 6-4
Privileges
querying metadata about 8-58/8-61
required to execute utilities 1-16
PROCESSH entity 15-7
Processor halt 14-1
Processors 14-1
Production system, steps for moving
applications to 11-6
Program files
moving to a production system 11-3
moving without compiled
modules 11-4, 11-6
Programs
backing up and restoring 11-28
constraints 16-13
description of 11-1, 15-8
distributing across nodes 11-8
integrating new columns 9-6
versioning issues for a distributed
database environment 11-8
Prohibition on using floating-point columns
in partitioning keys 7-16
PURGEDATA
deleting table data 10-36
guidelines 10-35
Purging the DDL directory of dropped
tables 10-1
Q
Queries
buffer size 16-11
enhancing performance 16-1
multinode 14-2
optimization 7-38
partitioning data 7-17
Query execution plan, factors
affecting 11-14
Querying metadata
See Metadata, querying
QUERY_CACHE 6-8
QUERY_CACHE_
STATEMENT_PINNING 6-9
QUERY_CACHE_MAX_ VICTIMS 6-8
QUERY_CACHE_REQUIRED_
PREFIX_KEYS 6-9