docs.intersystems.com
Home / InterSystems SQL Optimization Guide

InterSystems SQL Optimization Guide
Next section
InterSystems: The power behind what matters   
Search:  


Preface : 
 
Chapter 1: 
 
1.1 Table Definition Optimization
1.2 Table Data Optimization
1.3 Query Optimization
1.4 Configuration Optimization
1.5 Sharding
1.6 Fast Commands
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
3.3 Tune Table Calculated Values
3.4 Exporting and Re-importing Tune Table Statistics
Chapter 4: 
 
4.1 Cached Queries Improve Performance
4.2 Creating a Cached Query
4.3 Literal Substitution
4.4 Cosharding Comment Option
4.5 Run Time Plan Choice
       4.5.1 Activating RTPC
       4.5.2 Application of RTPC
       4.5.3 Overriding RTPC
4.6 Cached Query Result Set
4.7 Existing Cached Queries
4.8 Executing Cached Queries
4.9 Cached Query Lock
4.10 Purging Cached Queries
       4.10.1 Remote Systems
4.11 SQL Statements That Are Not Cached
Chapter 5: 
 
5.1 Management Portal SQL Performance Tools
5.2 SQL Runtime Statistics
5.3 Using the SQL Runtime Statistics Tool
       5.3.1 Settings
       5.3.2 Query Test
       5.3.3 View Stats
       5.3.4 Runtime Statistics and Show Plan
5.4 Using Performance Statistics Methods
5.5 Using Indices
5.6 Show Plan
5.7 Alternate Show Plans
       5.7.1 Stats
5.8 Writing Query Optimization Plans to a File
5.9 Comment Options
       5.9.1 Syntax
       5.9.2 Display
5.10 Parallel Query Processing
5.11 Generate Report
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 Listing Columns
       7.2.2 Plan State
       7.2.3 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
7.8 Exporting and Importing SQL Statements
Chapter 8: 
 
8.1 How to Use Frozen Plans
8.2 Software Version Upgrade Automatically Freezes Plans
8.3 Frozen Plans Interface
       8.3.1 Privileges
       8.3.2 Frozen Plan Different
       8.3.3 Frozen Plan in Error
8.4 %NOFPLAN Keyword
8.5 Exporting and Importing Frozen Plans


Next section
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-06-18 10:01:59