HP 3000 Manuals

ALLBASE/SQL Performance Guidelines

Chapter 3  Guidelines on Query Design 

Careful query design is of primary importance for performance.  In most
queries, the most efficient retrieval of data occurs when an index is
used.  You cannot directly choose to use an index; the ALLBASE/SQL query
optimizer decides whether to use an index or not, and if so, it decides
which one to use.  However, through careful query design, you can ensure
that the optimizer is able to choose an available index.  Topics included
in this chapter are as follows:

   *   Avoiding Serial Scans Through Query Design.
   *   Using Subqueries.
   *   Using UNION.
   *   Using MIN/MAX Functions in Predicates.
   *   Using OR Predicates.
   *   Using Predicates with LIKE.
   *   Using Predicates with BETWEEN.
   *   Using Fetch Unique Scans.
   *   Updating Key Columns.
   *   Avoiding User Propagation of Filters.
   *   Using TID Scans.
   *   Using the BULK Option.
   *   Analyzing Queries with GENPLAN.

MPE/iX 5.0 Documentation