HPlogo ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 Computer Systems

Index
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		   

A

aborting programs
with TERMINATE USER, Developing Application Programs
administration
DBA guidelines, DBA Guidelines
HP-UX guidelines, HP-UX System Guidelines
system, Guidelines on System Administration
aging
in data buffer calculations, Keeping a Small Group of Pages in Memory
arithmetic expressions
causing serial scans, Arithmetic Expressions
authorization
effect on performance, Authorization Design

B

B-tree
and indexes, How Indexes are Used
balancing load
by separating files, Balancing System Load
batch reports
with SQLMON, Creating Batch Reports
BEGIN WORK
monitoring, Field Definitions
BETWEEN
optimization of, Using Predicates with BETWEEN
buffer
calculating size of log buffer, Choosing a Number of Log Buffer Pages
log data, Log Buffering
monitoring I/O, IO Screen
types used by ALLBASE/SQL, Data Buffering
BULK option
in queries, Using the BULK Option

C

caching
of directory information, Directory Caching
of sections and DBCore directory, Section Caching and Directory Caching
stored sections, Section Caching
calculations
overhead, Including Calculated Data in Tables
checkpoints
monitoring, Field Definitions
cluster count
and indexes, Monitoring the Cluster Count
defined, Cluster Count
clustering indexes
monitoring, Static Cluster Screen
using, Clustering Indexes
COMMIT WORK
and log buffer, Log File Organization
causing I/O, Using Short Transactions and Savepoints
monitoring, Field Definitions
compatibility
of data types, Data Conversions
compression
of data pages, Page Compression
concurrency
improving, Creating Tables
conjunctive normal form
in OR optimization, How OR Predicates are Optimized
constraint
PCR, How PCRs are Stored
conversion
avoiding in UNION operations, Avoiding Conversions
of data, Data Conversions
SMALLINT to INTEGER, Using INTEGER Rather than SMALLINT Data
correlated subqueries
effect on performance, Using Subqueries
cursor stability (CS)
using, Using CS, RC, and RU Isolation Levels

D

data
conversion, Creating Tables, Data Conversions, Avoiding Conversions
logical design, Logical Data Design
physical design, Physical Data Design
data buffer
high miss rate, High Data Buffer Miss Rate
insufficient space, Insufficient Data Buffer Space
miss rate, Field Definitions
swapping, Using the SET SAMPLING Command
data buffer pages
adjusting with SQLMON, An Empirical Approach
calculating number of, Choosing a Number of Data Buffer Pages
monitoring I/O, IO Screen
monitoring objects, SampleIO Objects Screen
monitoring swapping, Field Definitions
used by ALLBASE/SQL, Data Buffering
data definition
reduces concurrency, General Tips on Managing Transactions
data storage
data page compression, Page Compression
DBA guidelines
for system administration, DBA Guidelines
DBCORERR
deadlock, Step 2 Set Up the Freeze
lock allocation failure, Step 2 Set Up the Freeze
DBEFile
defined, Creating DBEFiles
monitoring capacity, Static DBEFile Screen
organization, DBEFile Organization
DBEFileSet
defined, Creating DBEFileSets
determining contents, Static Screen
full, Full DBEFileSets
DBEnvironment
specifying in SQLMON, Specifying the DBEnvironment
DDL Enabled flag
and directory caching, Directory Caching
improving concurrency, General Tips on Managing Transactions
setting to NO, Developing Application Programs
deadlock
and savepoints, Using Short Transactions and Savepoints
caused by locking, Controlling Locking
detection, Locks
example in SQLMON, Deadlocks
monitoring, Field Definitions
default value
adding column with, Creating Tables
deletions
tips on, Tips on Deletions from Tables
design
logical, Logical Data Design
of queries, Guidelines on Query Design
physical, Physical Data Design
detached files
identifying, Monitoring Disk Usage
directory caching
defined, Section Caching and Directory Caching
when DDL Enabled is set to NO, Directory Caching
dirty reads
defined, Using CS, RC, and RU Isolation Levels
disjunctive normal form
in OR optimization, How OR Predicates are Optimized
disk space
increasing usage, Gathering Small Tables into DBEFileSets
monitoring, Monitoring Disk Usage
used for sorting, Disk Space for Sorting
display options
setting for SQLMON, Setting SQLMON Variables
dynamic statements
performance of , Tuning Performance of Dynamic Statements

E

echoing
SQLMON batch input, SET ECHO
editor
high performance, for tables, Design for a High-Performance Interactive Table Editor
EXIT, EXIT

F

factor
in optimization, How Optimization is Done
file
load balancing, Balancing System Load
monitoring capacity, Static DBEFile Screen
opening, Gathering Small Tables into DBEFileSets
raw, Creating DBEFiles
running out of space, Creating DBEFiles
saving space, Avoiding Extra DBEFile Space
filtering SQLMON information
DBEFileSets, SET DBEFILESET
lock mode, SET LOCKFILTER
lock object, SET LOCKOBJECT
number of items displayed, SET TOP
filters
avoiding propagation by user, Avoiding User Propagation of Filters
format
data page, Page Organization
DBEFile, DBEFile Organization
page table page, Page Table Pages
rows of user data on data pages, Storage of Table Data on DBEFile Pages
TID, Storage of Table Data on DBEFile Pages
tuple header, Storage of Table Data on DBEFile Pages
freezing
to examine deadlock, Step 2 Set Up the Freeze
to examine lock allocation failure, Step 2 Set Up the Freeze

G

GENPLAN
analyzing queries with, Analyzing Queries with GENPLAN
using to observe the optimizer's choices, Using GENPLAN

H

hanging
SQLMON session, Description
hashing
and TRUNCATE TABLE, Tips on Deletions from Tables
compared to B-tree index, Choosing Appropriate Index Types
monitoring overflow pages, Hash Overflow Pages
monitoring tasks, Monitoring Hash Structures
removing overflow pages, Unloading and Reloading to Remove Overflow Pages
storage on DBEFile pages, Hash Storage
using, Using Hash Structures
HELP, HELP
host variables
and scan buffer, Data Buffering
hot spots
defined, Benefits of Row Level Locking
HP-UX
setting parameters for, HP-UX System Guidelines

I

I/O
balancing load of, SampleIO Subsystem
caused by COMMIT WORK, Using Short Transactions and Savepoints
data buffers, Data Buffering
empty DBEFile space, Avoiding Extra DBEFile Space
fastest available disk, Building Indexes on Large Tables
flooding with checkpoints, Nonarchive Log Guidelines
improving, Creating DBEFiles
incurred by inserts, Using Hash Structures
log buffers, Choosing a Number of Log Buffer Pages
minimizing disk contention, Placing Concurrently Used Objects on Different Drives
monitoring buffers, IO Screen
monitoring data I/O, Monitoring I/O for Data
monitoring for DBEFile, SampleIO Screen
monitoring for indexes, SampleIO Indexes Screen
monitoring for logging, IO Log Program Screen
monitoring for program, IO Data Program Screen
monitoring for sessions, IO Data Session Screen
monitoring for tables, SampleIO Tables Screen
monitoring logging I/O, Monitoring I/O for Logging
nested loop joins, Join Methods
shortening I/O path, Creating DBEFiles
small tables, Gathering Small Tables into DBEFileSets
system buffer pool, Data Buffering
wasted, Clustering Indexes
idx hashing
Static Hash Screen, Static Hash Screen
IMAGE database
storage of table, Field Definitions
index
B-tree compared to hashing, Using Hash Structures, Choosing Appropriate Index Types
B-tree splits and logging, No-Log Pages
BETWEEN predicates, Using Predicates with BETWEEN
clustering, Clustering Indexes
design of, B-Tree Index Design
LIKE predicates, Using Predicates with LIKE
maintaining, Maintaining Indexes
MIN/MAX predicates, Using MIN/MAX Functions in Predicates
monitoring clustering, Static Cluster Screen
monitoring I/O, SampleIO Indexes Screen
monitoring tasks, Monitoring Indexes and Referential Constraints
NULL values, Avoiding NULL and Variable Length Data
OR predicates, Using OR Predicates
page splitting, Page Splitting
placement on disks, Balancing System Load
poorly clustered, Poorly Clustered Indexes
storage on DBEFile pages, Storage of Index Data on DBEFile Pages
table size, Table Size
to improve I/O, Creating DBEFiles
UNION queries, Defining Indexes for UNION Queries
USASCII columns, Creating Tables
when needed, Creating Tables
indirect row
avoiding, Indirect Rows
defined, Indirect Rows
monitoring, Static Indirect Screen
unloading and reloading to avoid, Unloading and Reloading to Remove Indirect Rows
INSTALL
after preprocessing, Developing Application Programs
IO Data Program Screen, IO Data Program Screen
IO Data Session Screen, IO Data Session Screen
IO Log Program Screen, IO Log Program Screen
IO Log Session Screen, IO Log Session Screen
IO Screen, IO Screen
IO subsystem, IO Subsystem
isolation level
determining, Monitoring Transactions
improving concurrency with, Using CS, RC, and RU Isolation Levels
KEEP CURSOR, Using KEEP CURSOR
locking of system catalog, System Catalog
locks, Locks
sorted query results, Using CS, RC, and RU Isolation Levels
types of, Guidelines on Transaction Design

J

joins
avoiding, Creating Tables
compared with subqueries, Using Subqueries
denormalizing instead of, Denormalizing Tables that are Consistently Joined
nested loop, Optimization, Join Methods
optimization of, Optimization
sort/merge, Sorting, Optimization, Join Methods

L

latch
use of, Latches
leaf pages
storage, Storage of Index Data on DBEFile Pages
LIKE
optimization of, Using Predicates with LIKE
LOAD
hashed table, Using Hash Structures
initial, Initial Table Loads
non-hash table, Creating Tables
to avoid indirect rows, Unloading and Reloading to Remove Indirect Rows
to improve cluster count, Guidelines on Logical and Physical Design
to recluster indexes, Reclustering a Table
to remove overflow pages, Unloading and Reloading to Remove Overflow Pages
load balancing
explained, Balancing System Load
Load Program Screen, Load Program Screen
Load Screen, Load Screen
Load Session Screen, Load Session Screen
Load subsystem, Load Subsystem
Lock Impede Screen, Lock Impede Screen
Lock Memory Screen, Lock Memory Screen
lock object
defined, Shared Memory Considerations
Lock Object Screen, Lock Object Screen
Lock Screen, Lock Screen
Lock Session Screen, Lock Session Screen
Lock subsystem, Lock Subsystem
Lock TabSummary Screen, Lock TabSummary Screen
locking
allocation failures, Lock Allocation Failures
and deadlocks, Deadlocks
avoiding contention, Using a Duplicate Database
cause of waits, Lock Impede Screen
causing delays, Lock Waits
causing transaction delays, Transaction Delays
contention, Lock Contention
filtering information, SET LOCKFILTER
for KEEP CURSOR, Using KEEP CURSOR
influenced by data definition, General Tips on Managing Transactions
monitoring contention, Lock Contention
monitoring tasks, Monitoring Locking
on the system catalog, System Catalog
overview, Locking and Latching
requests, Field Definitions
row level, Using Row Level Locking
selecting types of, Guidelines on Transaction Design
sequence of events, Sequence of Events in Locking Data
SQLMON screens, Lock Screen
subsystem in SQLMON, Lock Subsystem
wait %, Field Definitions
waits, Field Definitions
logging
archive mode on IO screen, Field Definitions
choosing number and size of files, Choosing the Number and Size of Log Files
choosing number of buffer pages, Choosing a Number of Log Buffer Pages
definition of log, Log File Organization
file capacity, Log Full Condition
file placement on disks, Balancing System Load
insufficient buffer space, Insufficient Log Buffer Space
monitoring errors, Field Definitions
monitoring file space, Field Definitions
monitoring I/O, IO Screen
monitoring program I/O, IO Log Program Screen
monitoring session I/O, IO Log Session Screen
monitoring tasks, Monitoring I/O for Logging
using raw files, Using HP-UX Raw Files for DBEFiles and Logs
LRU (least recently used) algorithm
in calculating data buffer pages, Keeping a Small Group of Pages in Memory

M

memory
available real, Cautions
latches, Latches
limit reached, Memory Limit Reached
locks, Locks
monitoring usage , Monitoring Memory Usage
row level locks, Shared Memory Considerations
shared, calculating, Calculating Shared Memory Allocation
used in sorting, Memory Utilization in Sorting
menus
displaying in SQLMON, SET MENU
MIN/MAX
optimization of, Using MIN/MAX Functions in Predicates
monitoring
with SQLMON , Monitoring Tasks
multiconnect
using, Using Multiconnect Functionality

N

nested loop join
explained, Join Methods
network use
guidelines for, Network Guidelines
NLS data
USASCII columns, Creating Tables
non-correlated subqueries
effect on performance, Using Subqueries
non-leaf pages
storage, Storage of Index Data on DBEFile Pages
normalization
in logical design, Normalization Issues
pros and cons, Normalization Issues
NULL values
avoiding, Avoiding NULL and Variable Length Data
indirect rows, Indirect Rows
tuple migration, Avoiding NULL and Variable Length Data

O

operating system buffer
used by ALLBASE/SQL, Data Buffering
optimization
BETWEEN predicates, Using Predicates with BETWEEN
LIKE predicates, Using Predicates with LIKE
MIN/MAX predicates, Using MIN/MAX Functions in Predicates
OR predicates, Using OR Predicates
overview, Optimization
updates of key columns, Updating Key Columns
optimizer
choice of join method, Join Methods
observing results with GENPLAN, Using GENPLAN
overriding with SETOPT, Using SETOPT
OR
optimization of, Using OR Predicates
organization
DBEFile, DBEFile Organization
page, Page Organization
output
of SQLMON, SET OUTPUT
overhead
generated by SQLMON, Overhead Generated by SQLMON
overnormalization
avoiding, Normalization Issues
Overview Program Screen, Overview Program Screen
Overview Screen, Overview Screen
Overview Session Screen, Overview Session Screen
Overview subsystem, Overview Subsystem

P

page
clean, Data Buffering
compression, Page Compression
dirty, Data Buffering, Using CS, RC, and RU Isolation Levels
in DBEFiles, Page Organization
no-log, No-Log Pages
overflow , Hash Storage
page splitting
of B-tree indexes, Page Splitting
page table page
defined, Page Table Pages
in DBEFiles, Creating DBEFiles
parallel serial scans
advantages of, Using Parallel Serial Scans
PCR
defined, How PCRs are Stored
performance
basic concepts, Basic Concepts in ALLBASE/SQL Performance
summary of topics, Guidelines on Logical and Physical Design
pin
use of, Pins
predicate
BETWEEN, Using Predicates with BETWEEN
LIKE, Using Predicates with LIKE
MIN/MAX, Using MIN/MAX Functions in Predicates
OR, Using OR Predicates
preprocessing
with a development DBE, Developing Application Programs
procedures
and rules, Using Procedures and Rules
program
monitoring data I/O, IO Data Program Screen
monitoring load, Load Program Screen
monitoring logging I/O, IO Log Program Screen
monitoring status, Overview Program Screen
propagation of filters
avoiding, Avoiding User Propagation of Filters
PUBLIC ROW
overview, Using Row Level Locking

Q

queries
design of, Guidelines on Query Design
importance in design, Logical Data Design

R

raw files
and I/O, Creating DBEFiles
using, Using HP-UX Raw Files for DBEFiles and Logs
read committed (RC)
using, Using CS, RC, and RU Isolation Levels
read uncommitted (RU)
using, Using CS, RC, and RU Isolation Levels
referential constraint
and index design, B-Tree Index Design
and TRUNCATE TABLE, Tips on Deletions from Tables
enforced with a PCR, How PCRs are Stored
monitoring clustering, Static Cluster Screen
monitoring I/O, SampleIO Indexes Screen
monitoring tasks, Monitoring Indexes and Referential Constraints
REFETCH statement
and RC or RU, Removing Non-Database Processing from Transactions
refresh
setting cycle , SET CYCLE
setting rate, SET REFRESH
revalidation
avoiding at run time, Validating Your Applications Before Run Time
ROLLBACK WORK
and transactions, Rollbacks
monitoring, Field Definitions
row
how stored on DBEFile page, Rows of Data on Pages
row level locking
overview, Using Row Level Locking
rules
and procedures, Using Procedures and Rules
runtime control blocks
choosing size of, Choosing the Size of the Runtime Control Block
latches, Latches
locks, Locks
monitoring, Field Definitions
row level locking, Shared Memory Considerations
running out of, Memory Limit Reached

S

SampleIO Indexes Screen, SampleIO Indexes Screen
SampleIO Objects Screen, SampleIO Objects Screen
SampleIO Screen, SampleIO Screen
SampleIO subsystem, SampleIO Subsystem
SampleIO TabIndex Screen, SampleIO TabIndex Screen
SampleIO Tables Screen, SampleIO Tables Screen
sampling
setting display, SET DISPLAYSAMPLES
setting with SQLMON, SET SAMPLING
savepoint
defined, Using Short Transactions and Savepoints
scan buffer
different from data buffer, Data Buffering
scan type
avoiding serial scans, Avoiding Serial Scans Through Query Design
overview of choices for optimization, Optimization
using parallel serial scans, Using Parallel Serial Scans
screens
invoking in SQLMON, Invoking SQLMON Screens
section caching
defined, Section Caching and Directory Caching
sections
defined, Sections and Validation
semi-permanent, Using Semi-Permanent Sections
SELECT
compared to FETCH with cursor, General Tips on Managing Transactions
design of, Guidelines on Query Design
session
monitoring data I/O, IO Data Session Screen
monitoring load, Load Session Screen
monitoring locks, Lock Session Screen, Overview Screen
monitoring logging I/O, IO Log Session Screen
monitoring status, Overview Session Screen
monitoring tasks, Monitoring Sessions
SET, SET
SET CYCLE, SET CYCLE
SET DBECONNECT, SET DBECONNECT
SET DBEFILESET, SET DBEFILESET
SET DBEINITPROG, SET DBEINITPROG
SET DBENVIRONMENT, SET DBENVIRONMENT
SET DISPLAYSAMPLES, SET DISPLAYSAMPLES
SET ECHO, SET ECHO
SET LOCKFILTER, SET LOCKFILTER
SET LOCKOBJECT, SET LOCKOBJECT
SET LOCKTABFILTER, SET LOCKTABFILTER
SET MENU, SET MENU
SET OUTPUT, SET OUTPUT
SET REFRESH, SET REFRESH
SET SAMPLING, SET SAMPLING
SET SORTIODATA, SET SORTIODATA
SET SORTIOLOG, SET SORTIOLOG
SET SORTLOAD, SET SORTLOAD
SET SORTLOCK, SET SORTLOCK
SET SORTSAMPLEIO, SET SORTSAMPLEIO
SET TOP, SET TOP
SET USERTIMEOUT, SET USERTIMEOUT
SETOPT
modifying access optimization plan with, Modifying the Access Optimization Plan with SETOPT
using to override the optimizer's choices, Using SETOPT
using to specify join method, Join Methods
shared memory
calculating, Calculating Shared Memory Allocation
shared tuple header
explained, Storage of Table Data on DBEFile Pages
size of objects
monitoring, Static Size Screen
slot table
defined, Slot Table
sort/merge join
explained, Join Methods
sorting
large sorts, Performance Hints for Large Sorts
methods used in ALLBASE/SQL, Sorting Operations
overview, Sorting
SQLMON
batch reports, Creating Batch Reports
defined, Introduction
leaving, Leaving SQLMON
monitoring tasks , Monitoring Tasks
online help, Accessing Online Help
screen command summary, Invoking SQLMON Screens
starting, Starting SQLMON
troubleshooting with, Troubleshooting with SQLMON
SQLMON Commands
EXIT, EXIT
HELP, HELP
SET, SET
SET CYCLE, SET CYCLE
SET DBECONNECT, SET DBECONNECT
SET DBEFILESET, SET DBEFILESET
SET DBEINITPROG, SET DBEINITPROG
SET DBENVIRONMENT, SET DBENVIRONMENT
SET DISPLAYSAMPLES, SET DISPLAYSAMPLES
SET ECHO, SET ECHO
SET LOCKFILTER, SET LOCKFILTER
SET LOCKOBJECT, SET LOCKOBJECT
SET LOCKTABFILTER, SET LOCKTABFILTER
SET MENU, SET MENU
SET OUTPUT, SET OUTPUT
SET REFRESH, SET REFRESH
SET SAMPLING, SET SAMPLING
SET SORTIODATA, SET SORTIODATA
SET SORTIOLOG, SET SORTIOLOG
SET SORTLOAD, SET SORTLOAD
SET SORTLOCK, SET SORTLOCK
SET SORTSAMPLEIO, SET SORTSAMPLEIO
SET TOP, SET TOP
SET USERTIMEOUT, SET USERTIMEOUT
SQLMON Screens
IO, IO Screen
IO Data Program, IO Data Program Screen
IO Data Session, IO Data Session Screen
IO Log Program , IO Log Program Screen
IO Log Session , IO Log Session Screen
Load, Load Screen
Load Program, Load Program Screen
Load Session , Load Session Screen
Lock, Lock Screen
Lock Impede, Lock Impede Screen
Lock Memory, Lock Memory Screen
Lock Object, Lock Object Screen
Lock Session, Lock Session Screen
Overview, Overview Screen
Overview Program, Overview Program Screen
Overview Session, Overview Session Screen
SampleIO, SampleIO Screen
SampleIO Indexes, SampleIO Indexes Screen
SampleIO Objects, SampleIO Objects Screen
SampleIO TabIndex, SampleIO TabIndex Screen
SampleIO Tables, SampleIO Tables Screen
Static, Static Screen
Static Cluster, Static Cluster Screen
Static DBEFile, Static DBEFile Screen
Static Hash, Static Hash Screen
Static Indirect, Static Indirect Screen
Static Size, Static Size Screen
summary, SQLMON Screens
Static Cluster Screen, Static Cluster Screen
Static DBEFile Screen, Static DBEFile Screen
Static Hash Screen, Static Hash Screen
Static Indirect Screen, Static Indirect Screen
Static Screen, Static Screen
Static Size Screen, Static Size Screen
Static subsystem, Static Subsystem
storage
B-tree indexes, Storage of Index Data on DBEFile Pages
hash tables, Hash Storage
log data, Log File Organization
user table data on DBEFile pages, Storage of Table Data on DBEFile Pages
subqueries
compared with joins, Using Subqueries
subsystem
IO, IO Subsystem
Load, Load Subsystem
Lock, Lock Subsystem
navigating in SQLMON, Navigating SQLMON Subsystems
Overview, Overview Subsystem
SampleIO, SampleIO Subsystem
Static, Static Subsystem
swapping
monitoring, Field Definitions
pages, Data Buffering
system administration
DBA guidelines, DBA Guidelines
HP-UX guidelines, HP-UX System Guidelines
network guidelines, Network Guidelines
system catalog
defined, System Catalog
DML only mode, General Tips on Managing Transactions
page locks on, Controlling Locking
query results , Controlling the Use of Temporary Space, Temporary Space in the SYSTEM DBEFileSet
sorting, Disk Space for Sorting
user data in, Avoiding the SYSTEM DBEFileSet for User Data
SYSTEM.INDEX
monitoring for cluster count, Monitoring the Cluster Count

T

table
and DBEFileSets, Placing Large Tables in Separate DBEFileSets
checking type, Field Definitions
indexes for large tables, Choosing Keys, Building Indexes on Large Tables
monitoring I/O, SampleIO Tables Screen
monitoring locks, Lock TabSummary Screen
monitoring tasks, Monitoring Tables
partitioning large tables, Horizontal Partitioning
size and row level locking, Benefits of Row Level Locking
storage on DBEFile pages, Storage of Table Data on DBEFile Pages
suggestions on creation, Creating Tables
temporary, Field Definitions
table editor
design for, Design for a High-Performance Interactive Table Editor
temporary space
controlling, Controlling the Use of Temporary Space
in sorting, Sorting, Creating Temporary Spaces
reported by SQLMON, Field Definitions
used in system catalog, Temporary Space in the SYSTEM DBEFileSet
terminal reads
avoiding locks around, Removing Non-Database Processing from Transactions, DELETE
TERMINATE USER
use of, Developing Application Programs
throttle wait queue
monitoring, Field Definitions
throughput
monitoring, Load Screen
TID
and indexes, How Indexes are Used
defined, Storage of Table Data on DBEFile Pages
on SampleIO Objects screen, Field Definitions
use of TID scans, Using TID Scans
timeout
and transaction limit, Transaction Limit Reached
setting for SQLMON, SET USERTIMEOUT
using, Using Timeouts to Tune Performance
transaction
delays, Transaction Delays
design of, Guidelines on Transaction Design
impeded, Field Definitions
limit reached, Transaction Limit Reached
maximum number of, Transaction Delays
monitoring tasks, Monitoring Transactions
monitoring with Load Screen, Load Screen
monitoring with Overview Screen, Overview Screen
using short transactions, Using Short Transactions and Savepoints
troubleshooting
with SQLMON, Troubleshooting with SQLMON
TRUNCATE TABLE
use of, Tips on Deletions from Tables
tuning hints, Parameters
tuple
how stored on DBEFile page, Rows of Data on Pages
tuple body
explained, Storage of Table Data on DBEFile Pages
tuple buffer
different from data buffer, Data Buffering
tuple header
explained, Storage of Table Data on DBEFile Pages
TurboIMAGE
storage of table, Field Definitions
types of data
compatibility of data types, Data Conversions

U

UNION
and indexes, Using UNION
avoiding conversions with, Using UNION
UNLOAD
to avoid indirect rows, Unloading and Reloading to Remove Indirect Rows
to improve cluster count, Monitoring the Cluster Count
to remove overflow pages, Unloading and Reloading to Remove Overflow Pages
UPDATE STATISTICS
cluster count, Monitoring the Cluster Count
indexes, Updating Statistics
invalidating sections, Validation
large tables, Placing Large Tables in Separate DBEFileSets
VALIDATE, Updating Statistics

V

VALIDATE
and UPDATE STATISTICS, Updating Statistics
validation
avoiding at run time, Validating Your Applications Before Run Time
explained, Validation
stored sections, Sections and Validation
VARCHAR data
and tuple migration, Avoiding NULL and Variable Length Data
variable length data
avoiding, Avoiding NULL and Variable Length Data

W

wait queue
monitoring, Field Definitions
timeouts, Using Timeouts to Tune Performance


Internal Algorithms
  		 
Feedback to webmaster