SQLite Code Factory online Help

Return to chapter overview

sql-statement ::=

EXPLAIN sql-statement

The EXPLAIN command modifier is a non-standard extension. The idea comes from a similar command found in PostgreSQL, but the operation is completely different.

If the EXPLAIN keyword appears before any other SQLite SQL command then instead of actually executing the command, the SQLite library will report back the sequence of virtual machine instructions it would have used to execute the command had the EXPLAIN keyword not been present. For additional information about virtual machine instructions see the architecture description or the documentation on available opcodes for the virtual machine.

Return to chapter overview

SQL Maestro Group wishes you a happy Thanksgiving!

We are pleased to grant you a 20% discount for all our products and bundles till the end of November!

News

Apr 10, 2017

Code Factories advanced to version 17.4

New version features colored tabs, new encryption algorithms in data grids, enhanced data input forms, updated data export/import tools and a lot of other useful things.

Sep 20, 2013

Code Factories are updated to version 13.9

New version comes with keyboard interactive SSH authentication, updated Script Runner, redesigned start page, improved SQL editors and data grids, as well as with many other useful things.

Mar 5, 2012

Code Factories advanced to version 12.3

New version introduces Unicode support in editors, updated code folding appearance, viewing BLOB data as PDF, data import from ODBC data source, Spanish translation and a lot of other new features.

More news

Feature of the day

Data Import

With SQLite Code Factory you can import data from Excel, CSV, text files and more.

Data management

SQLite Code Factory provides you with all the features (such as viewing, editing, grouping, sorting and filtering) to analyze the data in the most convenient way.

SQLite Code Factory online Help

EXPLAIN

Thanksgiving Sale