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:

Using Caché SQL provides in-depth material on SQL components and features, how to execute SQL queries, and support for error and transaction processing.
The Caché SQL Reference provides details on individual SQL commands and functions, as well as information on the Caché SQL data types and reserved words.
Caché Programming Orientation Guide is an orientation guide for programmers who are new to Caché or who are familiar with only some kinds of Caché programming.
In Using Caché Objects, the chapter “Introduction to Persistent Objects” summarizes how Caché object technology interoperates with SQL. Later chapters provide additional detail.
Using Caché with JDBC describes how to access Caché tables from external applications via JDBC.
Using Caché with ODBC describes how to access Caché tables from external applications via ODBC.
Caché Advanced Configuration Settings Reference describes the SQL configuration settings.
Caché Error Reference lists the SQLCODE error messages.