[top]
[prev]
[next]

Documentation Top
Global Index
Reference Manual
TOC Index
Grammar Index
Developer’s Guide
TOC Index
Tuning Cloudscape
TOC Index
|
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
- 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
- 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
- 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
- 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
- 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
- FLOAT
- java.sql type converted to DOUBLE PRECISION when retrieved
- Hash join strategy
,
- Hash joins
- requirements for
- use of memory
- 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
- 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
- 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
- Matching index scans
- definition
- MAX() optimization
- Memory
- allocating more memory to an application
- MIN() optimization
- Nested loop join strategy
,
- NIS+
- configuring
- 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
- 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
- Qualifiers
- in matching index scans
- Query optimization
- Recompiling
- when advisable
- Reserving space on a page
- Row-level locking
- disabling
- RunTimeStatistics
- overview
- using
- 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
- Table-level locking
- forcing for a specific table at creation time
- tmp directory
- setting location for
- Transitive closure
- UNION
- avoiding ordering during
- User authentication
- turning on
- User authorization
- configuring
, ,
- Users
- creating
- Verifying database-wide properties
- Verifying properties used in tables and indexes
- View flattening
- View transformations
- VTIs
- and costing information
|