Skip to main content

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