Performance Tuning

User Guide > Performance Tuning

Performance Tuning

This topic describes ways to fine-tune query execution to enhance performance.

• About Performance Tuning in TDV

• Working with the SQL Execution Plan

• Creating Cardinality Statistics for Cost-Based Optimization

• Using TDV API Procedures to Refresh or Cancel Resource Statistics

• Use Indexes, and Primary and Foreign Keys, to Improve Query Performance

• Types of Joins

• SQL Join Reordering

• Semijoin Optimization Option

• Star Schema Semijoin

• Using Oracle SQL Optimizer Hints

• Tuning Nested Aggregate Function Behavior

• Tuning Database Channel Queue Size

• Specifying the Fetch Size for Oracle and MS SQL Server