Index
Page 1 of 1

A - B - C - D - E - F - G - H - I - J - K - L
M - N - O - P - Q - R - S - T - U - V - W - X
Y - Z - Symbols - Numerics

Index

A

Access path
how optimizer chooses
overriding optimizer , , ,
when optimizer's cost estimates for it are accurate
when optimizer's cost estimates for it are less accurate
Application design
performance implications
Application performance
analyzing
Authentication
turning on
Authentication provider
specifying
Automatic stale plan invalidation

B

Base table
definition
BETWEEN transformations
Booting
configuring system
Bulk fetch
configuring system-wide default
how optimizer chooses
overriding system default ,
when useful
bulkFetch optimizer-override property

C

Caches
performance benefits of priming
Checkpoint
Class loading
enabling
how to minimize impact of
tuning
when it occurs in Cloudscape
Class path
performance implications of
Cloudscape properties
setting
cloudscape.authentication.ldap.searchAuthDN
cloudscape.authentication.ldap.searchAuthPW
cloudscape.authentication.ldap.searchbase
cloudscape.authentication.ldap.searchfilter
cloudscape.authentication.provider
cloudscape.authentication.server
cloudscape.connection.requireAuthentication
cloudscape.database.classpath
cloudscape.database.defaultConnectionMode
cloudscape.database.forceDatabaseLock
cloudscape.database.fullAccessUsers
cloudscape.database.noAutoBoot ,
cloudscape.database.propertiesOnly ,
cloudscape.database.readOnlyAccessUsers
cloudscape.infolog.append
cloudscape.jdbc.metadataStoredPreparedStatements
cloudscape.language.bulkFetchDefault
cloudscape.language.defaultIsolationLevel
cloudscape.language.logStatementText
cloudscape.language.preloadClasses
cloudscape.language.spsCacheSize
cloudscape.language.stalePlanCheckInterval
cloudscape.language.statementCacheSize ,
cloudscape.locks.deadlockTimeout
cloudscape.locks.deadlockTrace
cloudscape.locks.escalationThreshold ,
cloudscape.locks.monitor
cloudscape.locks.waitTimeout
cloudscape.properties file ,
cloudscape.service
cloudscape.storage.fileCacheSize
cloudscape.storage.initialPages
cloudscape.storage.minimumRecordSize
cloudscape.storage.pageCacheSize
cloudscape.storage.pageReservedSpace
cloudscape.storage.pageSize ,
cloudscape.storage.rowLocking
cloudscape.storage.sortBufferMax
cloudscape.storage.tempDirectory
cloudscape.stream.error.field
cloudscape.stream.error.file
cloudscape.stream.error.logSeverityLevel
cloudscape.stream.error.method
cloudscape.system.bootAll ,
cloudscape.system.home
cloudscape.system.home
determining location of cloudscape.properties
cloudscape.user
Compilation
avoiding by using PreparedStatements
avoiding by using stored prepared statements
performance hit
Compilation classes
loading at boot time
COM.cloudscape.database.Database
COM.cloudscape.database.PropertyInfo
COM.cloudscape.vti.VTICosting
Configuring Cloudscape
Conglomerate-specific properties
setting
verifying
constraint optimizer-override property
Covering indexes
Cursors
affected by indexes

D

Data page cache
performance benefits of increasing
Database design
performance implications
Database pages
preallocating
DatabaseMetaData
performance tip
Databases
booting all in system
booting upon connection only
external to system directory
Database-wide properties
protecting against overrides
protecting for embedded environment
setting
shortcut for setting
verifying value of
Deadlocks
monitoring
timeout property
tracing
wait timeout property
Derived tables
definition
DISTINCT
combined with ORDER BY
eliminated for uniqueness condition
Dynamic properties

E

Equality predicate
definition
Equijoin predicate
definition
Equijoins
optimizable
Error log
configuring severity of errors that appear in
redirecting to a stream ,
specifying file name
EXISTS join
definition
Expensive queries
how to avoid
importance of avoiding

F

FLOAT
java.sql type converted to DOUBLE PRECISION when retrieved

H

Hash join strategy ,
Hash joins
requirements for
use of memory

I

index optimizer-override property
Index use
analyzing ,
how optimizer chooses
Indexes
cost of maintaining
definition
how they work
performance benefits of ,
querying system tables to get system-generated name
when they are useful
Information log
overwriting
Internal transformation of statements
BETWEEN predicates
COUNT
LIKE predicates
OR predicates
predicates
Sort avoidance
static IN predicates
transitive closure
views
IN/ANY subquery transformation
Isolation levels
configuring default for system or database

J

java.sql.ResultSet.getXXX methods
performance implications of
JDBC DatabaseMetaData
improving performance of
JIT
performance benefits of
Join order
analyzing
how optimizer chooses
overriding optimizer
performance implications of ,
rules of thumb
Join strategies
how optimizer chooses
overriding optimizer
joinOrder optimizer-override property
Joins
optimizability of
performance factors
joinStrategy optimizer-override property
JVMs (Java Virtual Machines)
importance for performance

L

Language transformations for performance
Large database pages
requirement for more memory
LDAP
configuring , , , ,
LIKE transformations
Lock escalation
at runtime (for statement)
at runtime (for transaction)
by user
chosen by optimizer
threshold
Lock granularity
how optimizer chooses
tuning
LOCK TABLE statement
Locking
performance implications of
Locks
monitoring
LONGVARBINARY
java.sql type converted to BIT VARYING when retrieved
LONGVARCHAR
java.sql type converted to VARCHAR when retrieved

M

Matching index scans
definition
MAX() optimization
Memory
allocating more memory to an application
MIN() optimization

N

Nested loop join strategy ,
NIS+
configuring

O

Optimizable
definition ,
Optimizable equijoins
definition
Optimizable operators
Optimization
requirements for
Optimizer
accuracy of ,
correcting accuracy of by forcing table scans
decisions made by
description
overriding ,
Optimizer overrides
scope of
OR transformations
ORDER BY
cost-based avoidance of

P

Page cache size
configuring
Page size
configuring
performance implications of
performance trade-offs of large pages
Performance
key issues
Performance of statements
analyzing
Platforms
recommended
Predicates
definition
directly optimizable
indirectly optimizable
pushed down into views
PreparedStatements
performance benefits of
Properties
conglomerate-specific scope ,
database-wide scope
dynamic vs. static
implications of having various ways to set
in client/server mode ,
persistence of
precedence of
publishing
scope of
setting using a Properties object
system-wide scope ,
verifying
verifying for tables and indexes

Q

Qualifiers
in matching index scans
Query optimization

R

Recompiling
when advisable
Reserving space on a page
Row-level locking
disabling
RunTimeStatistics
overview
using

S

Sargable
definition
Selectivity assumptions of optimizer
Shutdown
performance benefits of
Simple column reference
definition
Sort avoidance ,
sort buffer
Stale statements
definition
Statement cache
performance benefits of ,
Statement execution
analyzing
debugging
Statement execution plan
Statement plans
automatic invalidation of
Statements
and stale statement execution plans
caching
debugging
when they are optimizable
Static IN transformations
Static properties
unable to set through SQL-J statement
Statistics timing attribute
use of
Storage properties ,
Stored prepared statement cache
Stored prepared statements
caching of across multiple connections
need to recompile ,
performance benefits of ,
performance hit caused by recompilation
sample values for parameters for optimization
staleness of requiring recompilation
what makes them invalid
Subqueries
elimination of DISTINCT in IN, ANY, and EXISTS subqueries
flattening of
flattening of to an EXISTS join
materialization of
processing and transformations of
System properties
setting in a Properties object
setting on command line
System-wide properties
setting

T

Table-level locking
forcing for a specific table at creation time
tmp directory
setting location for
Transitive closure

U

UNION
avoiding ordering during
User authentication
turning on
User authorization
configuring , ,
Users
creating

V

Verifying database-wide properties
Verifying properties used in tables and indexes
View flattening
View transformations
VTIs
and costing information