This chapter describes query plans, explains how the database server manages query optimization, and discusses factors that you can use to influence to affect the query plan. Performance considerations for SPL routine, the UDR cache, and triggers are also covered.
The parallel database query (PDQ) features in the database server provide the largest potential performance improvements for a query. Parallel Database Query, describes PDQ and the Memory Grant Manager (MGM) and explains how to control resource use by queries.
PDQ provides the most substantial performance gains if you fragment your tables as described in Fragmentation Guidelines.
Improving Individual Query Performance, explains how to improve the performance of specific queries.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]