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

Index
HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-4
D
CREATE INDEX statement
adding an index 9-8
description of 4-17
CREATE TABLE statement
adding columns 9-23
adding tables 9-15
creating table partitions 7-16
description of 7-11
CREATE VIEW statement 7-39
Creating catalogs 7-7
Creating constraints 7-37
Creating table partitions 7-16
C++ preprocessor 3-17
D
Damaged objects, deleting 12-36
Data
checking 1-4, 15-18
integrity constraints 15-19
partitioned 7-16
validity 1-4
views and consistency 4-11
Data consistency, checking 12-30
Data problems
correcting 12-32
identifying 12-27
Data types
ASCII 7-25
character 7-24
datetime 7-24
default column 7-30
DOUBLE PRECISION 7-26
FLOAT 7-26
guidelines 7-23
INTERVAL 7-27
matching 7-32
NCHAR 7-25
NUMERIC 7-24
performance issues 7-24
Data types (continued)
REAL 7-26
VARCHAR 7-25
Database
access costs 14-10
access strategy 4-11
altering objects 9-18
changing 9-1
crash-open files 12-1
detecting inconsistencies 8-60
enhancing performance 15-1
integrating new columns 9-6
management
environment 1-1
guidelines 9-1
tasks 1-13
tools 1-13
object naming 1-6
planning 4-1
production 1-1
protection and recovery 1-2
recovery, node failure 12-1
relocating 14-1
reorganization 10-3
SCF ALTER DISK issues 12-38
SCF ALTER DISK, LABEL
issues 12-39
SCF STOP DISK issues 12-40
test 12-40
Data, dropping 9-36
DBA (database administrator)
tasks 1-13
tools 1-13
DDL directory, purging dropped tables 10-1
DDL licensing product 3-5
DDL locks
consequences of a failed utility
operation 10-6
description of 10-5