Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Next section

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.