Skip Headers

# Query Optimization

Previous

Next

TopLink provides an extensive query API for reading, writing, and updating data. This section describes ways of optimizing query performance in various circumstances.

Before optimizing queries, consider the optimization suggestions in "Data Access Optimization".

This section includes information on the following:

- Parameterized SQL and Prepared Statement Caching

- Named Queries

- Batch and Join Reading

- Partial Object Queries and Fetch Groups

- JDBC Fetch Size

- Cursored Streams and Scrollable Cursors

- Read Optimization Examples

- Write Optimization Examples