SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Index
HP NonStop SQL/MX Installation and Management Guide—640325-001
Index-13
Q
alternate setting 6-4
ANSI compliance 6-8
Privileges
querying metadata about 8-65/8-68
required to execute utilities 1-12
PROCESSH entity 14-8
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-29
constraints 15-18
description of 11-1, 14-9
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-4
QUERY_CACHE_
STATEMENT_PINNING 6-5
QUERY_CACHE_MAX_ VICTIMS 6-4
QUERY_CACHE_REQUIRED_
PREFIX_KEYS 6-5
R
RDF
configuring disk volumes 5-22
creating a backup database with
identical file names 5-24
creating an online backup
database 5-24
creating backup catalogs 5-22
creating backup schemas 5-22
populating an online backup
database 5-25
recovering dropped tables 5-25
retrieving saved DDL 5-26
setting up a backup system 5-21
synchronizing a backup database 5-25
using Backup and Restore to create
offline backup databases 5-23
using Guardian names for SQL/MX
objects 5-21
using TGT CATALOG option of
RESTORE 5-23
using the LOCATION option 5-23
READONLY_CURSOR, ANSI
compliance 6-8
READs 14-11
REAL data type 7-26
RECOMPILATION_WARNING 6-5, 6-8
RECOMPILES counter, Measure 14-10
Recompiling a module 11-14
RECORDS-ACCESSED counter,
Measure 14-10, 14-11
RECORDS-USED counter, Measure 14-10,
14-11
RECOVER FILES command, TMF
description of 12-2, 12-10
example of 12-5
examples of 12-19