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)