Font size:

Index

Index

Index

Access path
- how optimizer chooses (482)
- when optimizer's cost estimates for it are accurate (505)
Application design
- performance implications (427)
Application performance
- analyzing (446)
Authentication
- turning on (527)
Authentication provider
- specifying (522)

Base table
- definition (573)
BETWEEN transformations (582)
Bulk fetch (494)
- how optimizer chooses (493)

Caches
- performance benefits of priming (411)
Cardinality statistics (502)
- definition (510)
- stale (512)
- working with (511)
Checkpoint (447)
Class loading
- how to minimize impact of (442)
- tuning (423)
- when it occurs in Derby (441)
Class path
- performance implications of (425)
derby.authentication.ldap.searchAuthDN (513)
derby.authentication.ldap.searchAuthPW (515)
derby.authentication.ldap.searchbase (517)
derby.authentication.ldap.searchfilter (519)
derby.authentication.provider (521)
derby.authentication.server (523)
derby.connection.requireAuthentication (526)
derby.database.defaultConnectionMode (529)
derby.database.forceDatabaseLock (531)
derby.database.fullAccessUsers (532)
derby.database.noAutoBoot (422)
derby.database.propertiesOnly (388), (534)
derby.database.readOnlyAccessUsers (536)
derby.infolog.append (538)
derby.language.logStatementText (540)
derby.locks.deadlockTimeout (543)
derby.locks.deadlockTrace (545)
derby.locks.escalationThreshold (492), (547)
derby.locks.monitor (549)
derby.locks.waitTimeout (552)
Derby properties
- setting (394)
derby.properties file (395), (400)
derby.storage.initialPages (554)
derby.storage.minimumRecordSize (556)
derby.storage.pageCacheSize (557)
derby.storage.pageReservedSpace (559)
derby.storage.pageSize (412), (561)
derby.storage.tempDirectory (563)
derby.stream.error.file (565)
derby.stream.error.logSeverityLevel (567)
derby.system.bootAll (421)
derby.system.home (569)
- determining location of derby.properties (402)
derby.user (570)
Compilation
- avoiding by using PreparedStatements (438)
- performance hit (437)
Configuring Derby (393)
Covering indexes (468)

Data page cache
- performance benefits of increasing (410)
Database design
- performance implications (426)
Database pages
- preallocating (555)
Database-wide properties
- protecting against overrides (535)
- protecting for embedded environment (389)
- setting (403)
- verifying value of (405)
Deadlocks
- monitoring (551)
- timeout property (544)
- tracing (546)
- wait timeout property (553)
Derived tables
- definition (574)
Descending indexes (431)
DISTINCT
- combined with ORDER BY (606)
- eliminated for uniqueness condition (605)
Dynamic properties (391)

Equality predicate
- definition (575)
Equijoin predicate
- definition (576)
Equijoins
- optimizable (479)
Error log
- configuring severity of errors that appear in (568)
- specifying file name (566)
EXISTS join
- definition (600)
Expensive queries
- how to avoid (436)
- importance of avoiding (435)

FLOAT
- java.sql type converted to DOUBLE PRECISION when retrieved (418)

Hash join strategy (476)
Hash joins
- requirements for (477)
- use of memory (480)

IN/ANY subquery transformation (602)
Index order
- performance implications of (432)
Index use
- analyzing (430), (444)
- how optimizer chooses (483)
Indexes
- cost of maintaining (470)
- definition (457)
- how they work (455)
- performance benefits of (409), (429)
- when they are useful (458)
Indexes with Descending Ordering
- performance benefits of (434)
Information log
- overwriting (539)
Internal transformation of statements (466)
- BETWEEN predicates (583)
- COUNT (608)
- LIKE predicates (585)
- OR predicates (589)
- predicates (581)
- Sort avoidance (604)
- static IN predicates (587)
- transitive closure (591)
- views (593)

java.sql.ResultSet.getXXX methods
- performance implications of (417)
Join order
- analyzing (445)
- how optimizer chooses (484)
- performance implications of (433), (472)
- rules of thumb (473)
Join strategies (474)
- how optimizer chooses (485)
Joins
- optimizability of (467)
- performance factors (471)

Language transformations for performance (572)
Large database pages
- requirement for more memory (416)
LDAP
- configuring (514), (516), (518), (520), (524)
LIKE transformations (584)
Lock escalation (548)
- at runtime (for transaction) (496)
- by user (498)
- chosen by optimizer (489)
- threshold (491)
Lock granularity
- how optimizer chooses (488)
LOCK TABLE statement (497)
Locking
- performance implications of (495)
Locks
- monitoring (550)
LONGVARBINARY
- java.sql type converted to VARCHAR FOR BIT DATA when retrieved (419)
LONGVARCHAR
- java.sql type converted to VARCHAR when retrieved (420)

Matching index scans
- definition (461)
MAX() optimization (500)
Memory
- allocating more memory to an application (415)
MIN() optimization (499)

Nested loop join strategy (475)

Optimizable
- definition (462), (577)
Optimizable equijoins
- definition (478)
Optimizable operators (464)
Optimization (453)
- requirements for (463)
Optimizer
- decisions made by (481)
- description (456)
OR transformations (588)
ORDER BY
- cost-based avoidance of (487)

Page cache size
- configuring (558)
Page size
- configuring (562)
- performance implications of (413)
- performance trade-offs of large pages (414)
Performance
- key issues (428)
Performance of statements
- analyzing (448)
Predicates
- definition (578)
- directly optimizable (460)
- indirectly optimizable (465)
- pushed down into views (595)
Prepared statements
- performance benefits of (439)
Properties
- conglomerate-specific scope (385)
- database-wide scope (384)
- dynamic versus static (392)
- implications of having various ways to set (408)
- in client/server mode (407)
- persistence of (386)
- precedence of (387)
- scope of (382)
- setting using a Properties object (398)
- system-wide scope (383), (396)

Qualifiers
- in matching index scans (469)
Query optimization (454)

Reserving space on a page (560)
Row counts
- when updated (504)
RunTimeStatistics
- overview (449)
- using (450)

Sargable
- definition (579)
Selectivity
- definition (506)
- from cardinality statistics (508)
- hard-wired assumptions (509)
- how it is determined (507)
Shutdown
- performance benefits of (424)
Simple column reference
- definition (580)
Sort avoidance (486), (603)
Statement cache
- performance benefits of (440)
Statement execution
- analyzing (443)
- debugging (541)
Statement execution plan (452)
Statements
- debugging (542)
- when they are optimizable (459)
Static IN transformations (586)
Static properties (390)
Statistics (501)
Statistics timing
- use of (451)
Subqueries
- elimination of DISTINCT in IN, ANY, and EXISTS subqueries (601)
- flattening of (598)
- flattening of to an EXISTS join (599)
- materialization of (597)
- processing and transformations of (596)
SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY (406)
SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY (404)
System properties
- setting in a Properties object (399)
- setting on command line (397)
System-wide properties
- setting (401)

Table-level locking
- forcing for a specific table at creation time (490)
Table row counts (503)
tmp directory
- setting location for (564)
Transitive closure (590)

UNION
- avoiding ordering during (607)
User authentication
- turning on (528)
User authorization
- configuring (530), (533), (537)
Users
- creating (571)

View flattening (594)
View transformations (592)

Previous Page
Table of Contents
Index