Firebird Documentation IndexFirebird 3.0.2 Release NotesMonitoring & Command-line Utilities → isql
Firebird Home Firebird Home Prev: gsecFirebird Documentation IndexUp: Monitoring & Command-line UtilitiesNext: fb_lock_print

isql

SET EXPLAIN Extensions for Viewing Detailed Plans
Metadata Extract
Path to INPUT Files
Command Buffer Size Increase
Deterministic Label for Stored Functions

SET EXPLAIN Extensions for Viewing Detailed Plans

Dmitry Yemanov

A new SET option is added: SET EXPLAIN [ON | OFF]. It extends the SET PLAN option to report the explained plan instead of the standard one.

If SET PLAN is omitted, then SET EXPLAIN turns the plan output on. SET PLANONLY works as in previous versions.

Usage options


  SET PLAN = simple plan + query execution
  SET PLANONLY = simple plan, no query execution
  SET PLAN + SET EXPLAIN = explained plan + query execution
  SET PLAN + SET EXPLAIN + SET PLANONLY = explained plan, no query execution
  SET EXPLAIN = explained plan + query execution
  SET EXPLAIN + SET PLANONLY = explained plan, no query execution
      

Metadata Extract

Claudio Valderrama C.

The metadata extract tool (-[e]x[tract] switch) was improved to create a script that takes the dependency order of objects properly into account.

A label has also been added, reflecting the deterministic flag for stored functions. (A. dos Santos Fernandes)

Path to INPUT Files

Adriano dos Santos Fernandes

The INPUT command will now use a relative path based on the directory of the last-opened, unclosed file in the chain to locate the next file.

Command Buffer Size Increase

Adriano dos Santos Fernandes

The size of the isql command buffer has increased from 64 KB to 10 MB to match the new engine limits. See Tracker ticket CORE-4148.

Deterministic Label for Stored Functions

Adriano dos Santos Fernandes

A label was added in the SHOW FUNCTION command reflecting the deterministic flag for stored functions.

See Tracker item CORE-4940.

Prev: gsecFirebird Documentation IndexUp: Monitoring & Command-line UtilitiesNext: fb_lock_print
Firebird Documentation IndexFirebird 3.0.2 Release NotesMonitoring & Command-line Utilities → isql