Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Tweak to the text of the EQP documentation. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
5f2171a4cb2245bc35d2dd5f57f770f4 |
| User & Date: | drh 2010-11-17 22:30:38 |
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
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> |