Caché SQL Optimization Guide
Contents
[Home]  [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

Preface : 
 
 
Chapter 1: 
 
1.1 Table Definition Optimization
1.2 Table Data Optimization
1.3 Query Optimization
1.4 Configuration Optimization
Chapter 2: 
 
2.1 Overview
2.2 Automatically-Defined Indices
2.3 Defining Indices
2.4 Bitmap Indices
2.5 Bitslice Indices
2.6 Building Indices
2.7 Validating Indices
2.8 Listing Indices
2.9 Open, Exists, and Delete Methods
Chapter 3: 
 
3.1 ExtentSize, Selectivity, and BlockCount
       3.1.1 ExtentSize
       3.1.2 Selectivity
       3.1.3 BlockCount
3.2 Tune Table
Chapter 4: 
 
4.1 Cached Queries Improve Performance
4.2 Literal Substitution
4.3 Cached Query Result Set
4.4 Existing Cached Queries
4.5 Executing Cached Queries
4.6 Cached Query Lock
4.7 Purging Cached Queries
       4.7.1 Remote Systems
4.8 SQL Statements That Are Not Cached
Chapter 5: 
 
5.1 Management Portal SQL Performance Tools
5.2 SQL Runtime Statistics
5.3 Using Indices
5.4 Show Plan
5.5 Alternate Show Plans
       5.5.1 Stats
5.6 Writing Query Optimization Plans to a File
5.7 Parallel Query Processing
Chapter 6: 
 
6.1 Tables Stored In Maps
6.2 Developing the Plan
6.3 Reading the Plan
6.4 Plan Analysis
Chapter 7: 
 
7.1 Operations that Create SQL Statements
7.2 Listing SQL Statements
       7.2.1 Plan State
       7.2.2 SQL Statement Text
7.3 Data Management (DML) SQL Statements
7.4 SQL Statement Details
7.5 Data Definition (DDL) SQL Statements
7.6 Delete Table and SQL Statements
7.7 Querying the SQL Statements
Chapter 8: 
 
8.1 How to Use Frozen Plans
8.2 Frozen Plans Interface
       8.2.1 Privileges
       8.2.2 Frozen Plan Different
       8.2.3 Frozen Plan in Error
8.3 %NOFPLAN Keyword
8.4 Exporting and Importing Frozen Plans