SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-3
C
Backing up (continued)
volume-mode 4-24
BACKUP command
AUDITED option 4-18, 11-8
backing up volumes 4-19
FROM CATALOG option 4-20
INDEXES EXPLICIT option 4-22
INDEXES IMPLICIT option 4-22
PARTONLY option 4-21
BACKUP utility
backing up SQL programs 9-34, 10-42
description 9-4
file, local and remote 9-6
moving tables 9-17, 9-19
Base tables
creating 5-10
creating views 5-38
description 1-2
using exclusively in database 3-13
BASETABS catalog table 6-4, 6-6
BEGIN WORK statement 4-16, 14-10
Benchmark, performance 13-1
Binding program files 10-1
Blocks
data 13-2
key-sequenced files 3-8
size 14-24
slack
APPEND 8-16
LOAD 8-8
RELOAD 8-3
BRIEF format
DISPLAY USE OF command 6-3
FILCHECK command 6-14
FILEINFO command 6-10
BROKEN flag 11-11
Buffer size, effect on query
performance 14-17
BUFFERED file attribute, similarity check
rules 10-28
C
Cache
sequential 14-17
setting 5-6
size 14-17
CALLS counter, Measure 13-9
CAST function 5-20
CATALOG catalog table, displaying version
information 6-15
CATALOG DEFINE, name resolution 10-13
Catalog tables
changing security 5-8, 7-17
description 5-2
indexes 5-3
joining 6-10
querying 6-3
securing 5-7
shorthand view creation 5-40
CATALOGNAME column 9-33
Catalogs
adding 7-2
altering attributes 7-15
altering statistics 14-14
backing up 4-18, 4-20
BROKEN flags 11-11
components 5-1
creating 1-3, 7-2
default 5-6
description 1-3, 5-1
distributed databases 12-4
distributed systems 12-5
downgrading 2-15, 2-16
dropping 7-29
DUP command and mapping
schemes 9-30
location requirements 5-4
multiple 5-5
names
listing 9-34