Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

About This Book

This book describes how to optimize performance of Caché SQL. Caché SQL provides standard relational access to data stored within a Caché 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 Caché SQL tables.

  • Cached Queries” describes how Caché 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 performance of your Caché 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:

For general information, see Using InterSystems Documentation.