Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
lang_explain.html

Index Summary Markup Original


R-47475-12388-30783-49021-03360-34906-23996-23410 tcl slt th3 src

Canonical usage: syntax/sql-stmt.html

th3/req1/lang01.test:17

/* IMP: R-47475-12388 */
# EVIDENCE-OF: R-47475-12388 -- syntax diagram sql-stmt

R-61942-17018-62236-02362-42701-24808-41313-47258 tcl slt th3 src

An SQL statement can be preceded by the keyword "EXPLAIN" or by the phrase "EXPLAIN QUERY PLAN".

th3/cov1/vdbeaux01.test:14

/* IMP: R-61942-17018 */
# EVIDENCE-OF: R-61942-17018 An SQL statement can be preceded by the
# keyword "EXPLAIN" or by the phrase "EXPLAIN QUERY PLAN".

R-37412-09436-16826-17483-13770-41037-63628-17339 tcl slt th3 src

Either modification causes the SQL statement to behave as a query and to return information about how the SQL statement would have operated if the EXPLAIN keyword or phrase had been omitted.

th3/cov1/vdbeaux01.test:17

/* IMP: R-37412-09436 */
# EVIDENCE-OF: R-37412-09436 Either modification causes the SQL
# statement to behave as a query and to return information about how the
# SQL statement would have operated if the EXPLAIN keyword or phrase had
# been omitted.

R-33352-16228-19462-25047-13980-23357-27400-59118 tcl slt th3 src

When the EXPLAIN keyword appears by itself it causes the statement to behave as a query that returns the sequence of virtual machine instructions it would have used to execute the command had the EXPLAIN keyword not been present.

th3/cov1/vdbeaux01.test:26

/* IMP: R-33352-16228 */
# EVIDENCE-OF: R-33352-16228 When the EXPLAIN keyword appears by itself
# it causes the statement to behave as a query that returns the sequence
# of virtual machine instructions it would have used to execute the
# command had the EXPLAIN keyword not been present.

R-01592-27714-26694-24809-12949-19667-58343-14650 tcl slt th3 src

When the EXPLAIN QUERY PLAN phrase appears, the statement returns high-level information regarding the query plan that would have been used.

th3/cov1/vdbeaux01.test:22   th3/req1/eqp01.test:22

/* IMP: R-01592-27714 */
# EVIDENCE-OF: R-01592-27714 When the EXPLAIN QUERY PLAN phrase appears,
# the statement returns high-level information regarding the query plan
# that would have been used.