Documentation Source Text

Check-in [5f2171a4cb]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Tweak to the text of the EQP documentation.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 5f2171a4cb2245bc35d2dd5f57f770f4b15c80f2
User & Date: drh 2010-11-17 22:30:38.000
Context
2010-11-18
01:11
Another minor change to the EQP documentation. (check-in: 1aff231013 user: drh tags: trunk)
2010-11-17
22:30
Tweak to the text of the EQP documentation. (check-in: 5f2171a4cb user: drh tags: trunk)
01:32
Add the sqlite3_stmt_readonly() function to the change log. (check-in: c591c1b79d user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/eqp.in.
︙︙
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

  the table rows are visited. ^(Each SCAN or SEARCH record includes the
  following information:

<ul>
  <li> The name of the table data is read from.
  <li> Whether or not an index or [automatic indexing|automatic index] is used.
  <li> Whether or not the [covering index] optimization applies.
  <li> The selectivity of the subset of records scanned.
  <li> The estimated number of rows that SQLite expects the scan to visit.
</ul>)^

<p>
  For example, the following EXPLAIN QUERY PLAN command operates on a SELECT
  statement that is implemented by performing a full-table scan on table t1:
^(<codeblock>








|








49
50
51
52
53
54
55
56
57
58
59
60
61
62
63

  the table rows are visited. ^(Each SCAN or SEARCH record includes the
  following information:

<ul>
  <li> The name of the table data is read from.
  <li> Whether or not an index or [automatic indexing|automatic index] is used.
  <li> Whether or not the [covering index] optimization applies.
  <li> Which terms of the WHERE clause are used for indexing.
  <li> The estimated number of rows that SQLite expects the scan to visit.
</ul>)^

<p>
  For example, the following EXPLAIN QUERY PLAN command operates on a SELECT
  statement that is implemented by performing a full-table scan on table t1:
^(<codeblock>
︙︙