# How this guide is organized

This guide includes the following sections:

- 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
- Internal language transformations

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

Parent topic: About this guide
Related concepts
Purpose of this guide
Audience