Firebird Documentation IndexFirebird 2.0.6 Release Notes → Optimizations
Firebird Home Firebird Home Prev: Firebird Index Structure from ODS11 OnwardFirebird Documentation IndexUp: Firebird 2.0.6 Release NotesNext: Optimizer Improvements

Optimizations

Table of Contents

Improved PLAN Clause
Optimizer Improvements

Improved PLAN Clause

D. Yemanov

A PLAN clause optionally allows you to provide your own instructions to the engine and have it ignore the plan supplied by the optimizer. Firebird 2 enhancements allow you to specify more possible paths for the engine. For example:

   PLAN (A ORDER IDX1 INDEX (IDX2, IDX3))
    

For more details, please refer to the topic in the DML section, Query Plans, Improvements in Handling User-specified Query Plans.

Prev: Firebird Index Structure from ODS11 OnwardFirebird Documentation IndexUp: Firebird 2.0.6 Release NotesNext: Optimizer Improvements
Firebird Documentation IndexFirebird 2.0.6 Release Notes → Optimizations