SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-9
E
DML statements
description 1-10
local autonomy 12-5
security considerations 4-4
Double buffering 14-18
DOUBLE PRECISION data type 5-22
Downgrading catalogs 2-16
Downtime by program, preventing 10-25
DROP CONSTRAINT statement 10-16
DROP INDEX statement 10-16
DROP statement
COLLATION 7-34
description 7-28
VIEW 7-30
DROP TABLE statement 10-16
DROP VIEW statement 10-16
DSAP utility 11-36
DSL statements 1-10
DSLACK option
APPEND command 8-16
LOAD command 8-7
RELOAD command 8-3
Dump
See also Backing up
file recovery 11-13
online 4-11, 9-14
DUP command, FUP and SQLCI 10-40,
10-42
DUP utility
catalog mapping schemes 9-30
CATALOG option 9-30
database move example 9-27
description 9-4
INDEXES OFF option 9-19, 9-23
moving collations 9-23
moving programs 10-44
moving tables 9-16
example 9-18
Dynamic SQL statement
CHECK option 10-22
query execution plans 10-12
D-series nodes, new features 2-12
E
EDIT files
for recovery 4-24, 11-8, 11-33
storing tables definitions 5-17
ELAPSED-BUSY-TIME counter,
Measure 13-9
ELAPSED-RECOMPILE-TIME counter,
Measure 13-9
Enhancing performance 14-1
Enscribe files
copying data 8-7
LOAD utility 8-10
removing B-1
restoring 11-10
unstructured 8-7
Entry-sequenced files 3-9, 5-14
Entry-sequenced tables 3-1, 5-14
Environment, database management 1-1
ESCALATIONS counters, Measure 13-10,
13-11
Estimated cost of compiled
statements 13-3
Execution
cost statistics 13-9
recompilation 10-7
SQLCI statistics display 13-3
Execution plans, altered 10-25
Execution-time name resolution
description 10-13
NOREGISTER option 10-41
similarity check 10-41
EXPLAIN DEFINEs option 10-33
EXPLAIN utility 7-5, 10-12
Explicit SQL compilation 10-6
EXTENT file attribute, similarity check
rules 10-28