Firebird Documentation Index → Firebird 3.0.6 Release Notes → Data Manipulation Language (DML) → Advanced Plan Output |
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
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.
Firebird Documentation Index → Firebird 3.0.6 Release Notes → Data Manipulation Language (DML) → Advanced Plan Output |