Caché SQL Optimization Guide

• About This Book
• Introduction to SQL Performance Optimization
• Table Definition Optimization
• Table Data Optimization
• Query Optimization
• Configuration 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
• ExtentSize, Selectivity, and BlockCount
• Tune Table
• 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
• Tables Stored In Maps
• Developing the Plan
• Reading the Plan
• Plan Analysis
• 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
• How to Use Frozen Plans
• Frozen Plans Interface
• %NOFPLAN Keyword
• Exporting and Importing Frozen Plans