Skip to main content
Next section

About This Book

This book describes how to optimize performance of InterSystems SQL. InterSystems SQL provides standard relational access to data stored within an InterSystems IRIS® data platform database.

The book addresses the following topics:

  • Defining and Building Indices” describes how to define and build indices.

  • Optimizing SQL Tables” describes ways that you can optimize access to the data in your InterSystems SQL tables.

  • Cached Queries” describes how InterSystems SQL retains recent queries in a cache, enabling rapid execution and sharing of defined queries.

  • Optimizing SQL Queries” describes ways that you can optimize the runtime performance of your InterSystems SQL queries.

  • SQL Performance Analysis Toolkit” describes tools for in-depth performance analysis of specific SQL queries.

  • Interpreting an SQL Query Plan” gives tips on understanding the results of a “show plan” for an SQL query.

  • SQL Statements” describes how you can view all executed SQL statements; queries provide performance statistics.

  • Frozen Plans” describes how you can view and freeze SQL query plans.

For a detailed outline, see the Table of Contents.

This book supplements the following:

FeedbackOpens in a new window