InterSystems SQL Optimization Guide
- Introduction to SQL Performance Optimization
- Table Definition Optimization
- Table Data Optimization
- Query Optimization
- Configuration Optimization
- Optimizing Large Tables using Sharding
- Fast Commands
- 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
- Tune Table Calculated Values
- Exporting and Re-importing Tune Table Statistics
- Cached Queries
- Cached Queries Improve Performance
- Creating a Cached Query
- Literal Substitution
- Cosharding Comment Option
- Runtime Plan Choice
- 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
- Query Execution Plans
- Alternate Show Plans
- Writing Query Optimization Plans to a File
- Comment Options
- Parallel Query Processing
- Generate Report
- SQL Performance Analysis Toolkit
- Interpreting an SQL Query Plan
- SQL Statements
- Operations that Create SQL Statements
- Listing SQL Statements
- Stale SQL Statements
- Data Management (DML) SQL Statements
- SQL Statement Details
- Querying the SQL Statements
- Exporting and Importing SQL Statements
- Frozen Plans