Caché SQL Optimization Guide
- About This Book
- Introduction to SQL Performance Optimization
- Defining and Building Indices
- Overview
- Automatically-Defined Indices
- Defining Indices
- Bitmap Indices
- Bitslice Indices
- Building Indices
- Validating Indices
- Listing Indices
- Open, Exists, and Delete Methods
- Optimizing Tables
- Cached Queries
- Cached Queries Improve Performance
- Literal Substitution
- Cached Query Result Set
- Listing Cached Queries
- Executing Cached Queries
- Cached Query Lock
- Purging Cached Queries
- SQL Commands That Are Not Cached
- Optimizing Query Performance
- Management Portal SQL Performance Tools
- SQL Runtime Statistics
- Using Indices
- Show Plan
- Alternate Show Plans
- Writing Query Optimization Plans to a File
- Parallel Query Processing
- Interpreting an SQL Query Plan
- SQL Statements
- Operations that Create SQL Statements
- Listing SQL Statements
- Data Management (DML) SQL Statements
- SQL Statement Details
- Data Definition (DDL) SQL Statements
- Delete Table and SQL Statements
- Querying the SQL Statements
- Exporting and Importing SQL Statements
- Frozen Plans