Home | Previous Page | Next Page

Tuning Specific Queries and Transactions

In This Chapter

Evaluating Query and Transaction Performance

Fundamental Query and Transaction Tuning Tasks

Create and Maintain Data-Distribution Statistics

Generating Statistics on a Table

Review the Isolation Level

Evaluate Filter Clauses

Evaluate Index Use

Choose Appropriate Columns for Indexes

Indexing Filter Columns in Large Tables

Avoiding Columns with Duplicate Keys

Improving Execution of Stored Procedures

SQL Statements That Contain a Call to an SPL Routine

SQL Statements in an SPL Routine

Tuning DSS Queries

Analyze Complex Query Plans

Generating Explain Output Without Executing Queries

Interpreting SET EXPLAIN Output

Displaying a Query Plan for a Distributed Query

Analyzing and Adjusting Memory Allocation

Tune Queries for Balanced Processing

Reduce the Effect of Join and Sort Operations

Avoiding or Simplifying Sort Operations

Using Temporary Tables to Reduce Sorting Scope

Create Appropriate Indexes for Queries

Creating Indexes for Key-Only Scans

Using Multiple Indexes on the Same Table

Creating Specialized Indexes

Prevent or Encourage Push-Down Hash Joins

Tuning OLTP Applications

Analyze Transaction Execution Plans

Ensure Quick Response for Transactions

Create Appropriate Indexes for Transactions

Indexing Columns Used in Group and Sort Statements

Using Composite Indexes

Using Optimizer Directives

Using Join-Order Directives with Views

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]