How This Document Is Organized

This document includes the following chapters:

• "Working with Derby Properties"

  An overview of how you set properties.

• "Performance tips and tricks"

  Quick tips on how to improve the performance of Derby applications.

• "Tuning databases and applications"

  A more in-depth discussion of how to improve the performance of Derby applications.

• "DML statements and performance"

  An in-depth study of how Derby executes queries, how the optimizer works, and how to tune query execution.

• "Selectivity and Cardinality Statistics"
• Appendix A, Internal Language Transformations

  Reference on how Derby internally transforms some SQL statements for performance reasons. Not of interest to the general user.