Firebird Documentation IndexFirebird 3.0.6 Release NotesData Manipulation Language (DML) → Advanced Plan Output
Firebird Home Firebird Home Prev: Window (Analytical) FunctionsFirebird Documentation IndexUp: Data Manipulation Language (DML)Next: Internal Functions

Advanced Plan Output

Dmitry Yemanov

Advanced PLAN Output in isql

PLAN output can now be output in a more structured and comprehensible form, e.g.

SELECT statement
   -> First [10]
     -> Sort [SUM, O_ORDERDATE]
       -> Aggregate
         -> Sort [L_ORDERKEY, O_ORDERDATE, O_SHIPPRIORITY]
           -> Inner Loop Join
             -> Filter
               -> Table ≪ORDERS≫ Access By ID
                 -> Bitmap
                   -> Index ≪ORDERS_ORDERDATE≫ Range Scan
             -> Filter
               -> Table ≪CUSTOMER≫ Access By ID
                 -> Bitmap
                   -> Index ≪CUSTOMER_PK≫ Unique Scan
             -> Filter
               -> Table ≪LINEITEM≫ Access By ID
                 -> Bitmap
                   -> Index ≪LINEITEM_PK≫ Unique Scan
    

Advanced PLAN Output in isql

New syntax SET EXPLAIN [ON | OFF ] has been added to the isql utility to surface this option. For details, refer to SET EXPLAIN Extensions for Viewing Detailed Plans in the Utilities chapter.

Prev: Window (Analytical) FunctionsFirebird Documentation IndexUp: Data Manipulation Language (DML)Next: Internal Functions
Firebird Documentation IndexFirebird 3.0.6 Release NotesData Manipulation Language (DML) → Advanced Plan Output