HP 3000 Manuals HP 3000 Manuals
Index
A
administration
DBA guidelines
HP-UX guidelines
MPE guidelines
system
aging
in data buffer calculations
arithmetic expressions
causing serial scans
authorization
effect on performance
B
balancing load
by separating files
BETWEEN
optimization of
buffer
calculating size of data buffer
calculating size of log buffer
log data
types used by ALLBASE/SQL
BULK option
in queries
C
caching
of directory information
of sections and DBCore directory
stored sections
cluster count
and indexes
defined
clustering indexes
using
compatibility
of data types
compression
of data pages
conjunctive normal form
in OR optimization
conversion
avoiding in UNION operations
from SMALLINT to INTEGER in SQLCore
of data in predicates
correlated subqueries
effect on performance
cursor stability (CS)
using
D
data
conversion
conversions forcing serial scan
logical design
physical design
data buffer
used by ALLBASE/SQL
data buffer pages
calculating number of
example of calculating
minimums, defaults, maximums
data definition
reduces concurrency
data storage
data page compression
DBA guidelines
for system administration
DBEFile
organization
DDL Enabled flag
setting to NO
design
logical
of queries
physical
directory caching
explained
when DDL Enabled is set to NO
disjunctive normal form
in OR optimization
E
editor
high performance, for tables
F
factor
in optimization
filters
avoiding propagation by user
format
of data pages
of DBEFiles
of page table pages
rows of user data on data pages
TID
tuple header
G
GENPLAN
using to observe the optimizer's choices
H
hash storage
on DBEFile pages
unloading and reloading to remove overflow pages
HP-UX
setting parameters for
I
index
and MIN/MAX predicates
and OR predicates
and predicates with BETWEEN
and predicates with LIKE
and UNION queries
cluster count and
clustering
design of
index storage
on DBEFile pages
indirect row
defined
unloading and reloading to avoid
initial table loads
INSTALL
after preprocessing
isolation level
and sorted query results
improving concurrency with
types of
K
KEEP CURSOR
and cursor operations
using
key columns
updating
L
latch
used to regulate access to shared elements
leaf pages
storage
LIKE
optimization of
LOAD
initial table loads
in sorted order
to avoid indirect rows
to improve cluster count
to remove overflow pages
load balancing
explained
locking
and data definition
and KEEP CURSOR
on the system catalog
overview
releasing shared locks with isolation levels
row level
selecting types of
sequence of events in locking data
used to regulate access to shared elements
log
defined
no-log pages
log buffer pages
calculating number of
using a large number
LRU (least recently used) algorithm
in calculating data buffer pages
M
memory
available real
shared, calculating
MIN/MAX
optimization of
MPE/iX
use of C and D queues
N
nested loop join
when used by optimizer
network use
guidelines for
NLS data
use of USASCII columns with
no-log pages
how used
non-correlated subqueries
effect on performance
non-leaf pages
storage
normalization
in logical design
pros and cons
NULL values
and tuple migration
O
operating system buffer
used by ALLBASE/SQL
optimization
and updates of key columns
of MIN/MAX predicates
of OR predicates
of predicates with BETWEEN
of predicates with LIKE
overview
OR
optimization of
organization
of DBEFiles
of pages
overflow page
defined
overnormalization
avoiding
P
page in DBEFile
defined
page splitting
of B-tree indexes
page table page
defined
PCR
defined
performance
basic concepts
summary of topics
pin
used to regulate access to shared elements
predicate
with BETWEEN
with LIKE
with MIN/MAX
with OR
preprocessing
using a development DBE for
propagation of filters
avoiding
Q
queries
design of
importance in design
R
read committed (RC)
using
read uncommitted (RU)
using
referential constraint
enforced with a PCR
REFETCH statement
and RC or RU
revalidation
avoiding at run time
row
how stored on DBEFile page
S
scan buffer
different from data buffer
scan type
overview of choices for optimization
section caching
explained
sections
invalidated by UPDATE STATISTICS
serial scans
avoiding
shared memory
calculating
shared tuple header
explained
slot table
defined
sorting
large sorts
methods used in ALLBASE/SQL
overview
sort/merge join
when used by optimizer
storage
B-tree indexes
hash tables
log data
of user table data on DBEFile pages
subqueries
compared with joins
system administration
DBA guidelines
HP-UX guidelines
MPE guidelines
network guidelines
system catalog
defined
SYSTEM.INDEX
monitoring for cluster count
T
table editor
design for
table storage
on DBEFile pages
TempSpace
in sorting
terminal reads
avoiding locks around
TID
defined
transaction
design of
using short transactions
tuple
how stored on DBEFile page
tuple body
explained
tuple header
explained
types of data
compatibility of data types
U
UNION
and indexes
avoiding conversions with
UNLOAD
to avoid indirect rows
to improve cluster count
to remove overflow pages
UPDATE STATISTICS
and cluster count
invalidating sections with
V
validation
avoiding at run time
explained
following UPDATE STATISTICS
stored sections
VARCHAR data
and tuple migration