User's Guide
PART 4. Database Administration and Advanced Use
This chapter describes some of the methods available to monitor and improve the performance of your database.
Top performance tips
Using keys to improve query performance
Using indexes to improve query performance
Search strategies for queries from more than one table
Sorting query results
Temporary tables used in query processing
How the optimizer works
Monitoring database performance