Allocate resources for DSS or OLTP systems.

Balance the load on system resources.

Collect performance statistics.

Control the placement and size of tables and table extents.

Create and manage indexes to speed up retrieval of data.

Design and use parallel database queries (PDQ).

Eliminate database server performance bottlenecks.

Fragment tables for improved performance.

Identify and monitor queries that are critical to performance.

Improve checkpoint performance and manage LRU queues.

Improve the performance of a query.

Manage data distributions.

Monitor critical system resources (CPU, memory, disk, virtual processors).

Monitor and track locking and isolation levels.

Optimize the disk layout.

Tune buffer cache.

Use case studies to tune performance.

Use optimizer directives and SET EXPLAIN to optimize query plans.

Use secondary access methods such as B-trees.

Use the onperf utility for performance monitoring and tuning.

Use the SQL statement cache.

Use UPDATE STATISTICS.

Write complex SQL statements, including outer joins and subqueries.