Table Of Contents

• Preface
• About This Manual
• 1. Introduction to Performance Tuning
• Introduction to SQL Tuning
• Database Server Tuning
• SQL Tuning
• 2. Altibase Server Tuning
• Log Files
• Checkpointing
• Buffers
• Service Threads
• Garbage Collector
• SQL Plan Cache
• CPU Usage
• 3. The Query Optimizer
• Query Optimizer Overview
• Query Conversion
• Creating Logical Execution Plans
• Creating Physical Execution Plans
• Optimizer-related Properties
• 4. The Explain Plan
• EXPLAIN PLAN Overview
• Displaying the Plan Tree
• Reading Plan Trees
• Using Plan Trees
• Plan Nodes
• 5. The Optimizer and Statistics
• Overview of Statistics
• Managing Statistics
• Auto Stats
• 6. SQL Hints
• Overview of Hints
• Types of Hints
• 7. SQL Plan Cache
• Overview of the SQL Plan Cache
• Managing the SQL Plan Cache
• Overview of the Result Cache