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

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-13
Q
Performance (continued)
column definitions 7-24
concurrency 15-2
data definitions 7-24
distributed databases 13-23
improving
description of 15-1
with index 4-18
index maintenance 15-17
indexes 4-12, 9-9
measuring 14-1/14-10
MODIFY utility 10-11
OLTP 7-41
partitioning data 7-16, 15-19
partitions 9-11
queries 15-2
statistics 14-1
testing 9-9
tools for analyzing 14-1
VARCHAR columns 7-24
views 15-19
Periodic backup 5-31
Physical file structure 4-3
Platform.h file 3-7, 3-14
PM_OFFLINE_TRANSACTION_
GRANULARITY 6-4
PM_ONLINE_TRANSACTION_
GRANULARITY 6-4
Post-installation tasks 3-15
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-31
creating and using 7-13
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION
alternate setting 6-8
ANSI compliance 6-13
DROPPABLE_OPTION (continued)
description of 6-4
Privileges
querying metadata about 8-56/8-59
required to execute utilities 1-12
PROCESSH entity 14-7
Production system, steps for moving
applications to 11-7
Program files
moving to a production system 11-3
moving without compiled
modules 11-5, 11-7
Programs
backing up and restoring 11-30
constraints 15-18
description of 11-1, 14-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-18
PURGEDATA
deleting table data 10-46
guidelines 10-45
Purging the DDL directory of dropped
tables 10-1
Q
Queries
buffer size 15-14
enhancing performance 15-2
optimization 7-40
partitioning data 7-17
Query execution plan, factors
affecting 11-13
Querying metadata
See Metadata, querying
QUERY_CACHE 6-9
QUERY_CACHE_
STATEMENT_PINNING 6-9