apache > db
Apache DB Project
 
Font size:      

Index

Index

A
  • Access path
    • how optimizer chooses (482)
    • when optimizer's cost estimates for it are accurate (505)
  • Application design
    • performance implications (427)
  • Application performance
  • Authentication
  • Authentication provider
B
  • Base table
  • BETWEEN transformations (582)
  • Bulk fetch (494)
    • how optimizer chooses (493)
C
  • Caches
    • performance benefits of priming (411)
  • Cardinality statistics (502)
  • 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
  • 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)
D
  • Data page cache
    • performance benefits of increasing (410)
  • Database design
    • performance implications (426)
  • Database pages
  • Database-wide properties
    • protecting against overrides (535)
    • protecting for embedded environment (389)
    • setting (403)
    • verifying value of (405)
  • Deadlocks
  • Derived tables
  • Descending indexes (431)
  • DISTINCT
    • combined with ORDER BY (606)
    • eliminated for uniqueness condition (605)
  • Dynamic properties (391)
E
  • Equality predicate
  • Equijoin predicate
  • Equijoins
  • Error log
    • configuring severity of errors that appear in (568)
    • specifying file name (566)
  • EXISTS join
  • Expensive queries
F
  • FLOAT
    • java.sql type converted to DOUBLE PRECISION when retrieved (418)
H
  • Hash join strategy (476)
  • Hash joins
I
  • IN/ANY subquery transformation (602)
  • Index order
    • performance implications of (432)
  • Index use
  • Indexes
  • Indexes with Descending Ordering
    • performance benefits of (434)
  • Information log
  • Internal transformation of statements (466)
J
  • java.sql.ResultSet.getXXX methods
    • performance implications of (417)
  • Join order
  • Join strategies (474)
    • how optimizer chooses (485)
  • Joins
    • optimizability of (467)
    • performance factors (471)
L
  • Language transformations for performance (572)
  • Large database pages
    • requirement for more memory (416)
  • LDAP
  • LIKE transformations (584)
  • Lock escalation (548)
  • Lock granularity
    • how optimizer chooses (488)
  • LOCK TABLE statement (497)
  • Locking
    • performance implications of (495)
  • Locks
  • LONGVARBINARY
    • java.sql type converted to VARCHAR FOR BIT DATA when retrieved (419)
  • LONGVARCHAR
    • java.sql type converted to VARCHAR when retrieved (420)
M
  • Matching index scans
  • MAX() optimization (500)
  • Memory
    • allocating more memory to an application (415)
  • MIN() optimization (499)
N
  • Nested loop join strategy (475)
O
  • Optimizable
  • Optimizable equijoins
  • Optimizable operators (464)
  • Optimization (453)
  • Optimizer
  • OR transformations (588)
  • ORDER BY
    • cost-based avoidance of (487)
P
  • Page cache size
  • Page size
    • configuring (562)
    • performance implications of (413)
    • performance trade-offs of large pages (414)
  • Performance
  • Performance of statements
  • 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)
Q
  • Qualifiers
    • in matching index scans (469)
  • Query optimization (454)
R
  • Reserving space on a page (560)
  • Row counts
  • RunTimeStatistics
S
  • Sargable
  • Selectivity
    • definition (506)
    • from cardinality statistics (508)
    • hard-wired assumptions (509)
    • how it is determined (507)
  • Shutdown
    • performance benefits of (424)
  • Simple column reference
  • Sort avoidance (486), (603)
  • Statement cache
    • performance benefits of (440)
  • Statement execution
  • Statement execution plan (452)
  • Statements
  • Static IN transformations (586)
  • Static properties (390)
  • Statistics (501)
  • Statistics timing
  • 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
T
  • 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)
U V
  • View flattening (594)
  • View transformations (592)

Previous Page
Table of Contents
Index