Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Leave unspecified what it means for the sqlite_stat3 and sqlite_stat4 tables to have idx columns equal to their tbl column. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
c538b41b9103463b25e1cc2b22a4d9de |
| User & Date: | drh 2013-09-19 14:24:33.124 |
Context
|
2013-09-19
| ||
| 14:30 | Clarification of the meaning of the stat column in sqlite_stat1. (check-in: 83b2bf0c4d user: drh tags: trunk) | |
| 14:24 | Leave unspecified what it means for the sqlite_stat3 and sqlite_stat4 tables to have idx columns equal to their tbl column. (check-in: c538b41b91 user: drh tags: trunk) | |
| 14:14 | Fix typos and enhance the text of documentation for 3.8.1 changes. (check-in: 1d0df412df user: drh tags: trunk) | |
Changes
Changes to pages/fileformat2.in.
| ︙ | ︙ | |||
1253 1254 1255 1256 1257 1258 1259 | <blockquote><pre> CREATE TABLE sqlite_stat3(tbl,idx,nEq,nLt,nDLt,sample); </pre></blockquote> <p>There are usually multiple entries in the sqlite_stat3 table for each index. The sqlite_stat3.sample column holds the value of the left-most field of an index identified by sqlite_stat3.idx and sqlite_stat3.tbl. | < < < | 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 | <blockquote><pre> CREATE TABLE sqlite_stat3(tbl,idx,nEq,nLt,nDLt,sample); </pre></blockquote> <p>There are usually multiple entries in the sqlite_stat3 table for each index. The sqlite_stat3.sample column holds the value of the left-most field of an index identified by sqlite_stat3.idx and sqlite_stat3.tbl. The sqlite_stat3.nEq column holds the approximate number of entries in the index whose left-most column exactly matches the sample. The sqlite_stat3.nLt holds the approximate number of entries in the index whose left-most column is less than the sample. The sqlite_stat3.nDLt column holds the approximate number of distinct left-most entries in the index that are less than |
| ︙ | ︙ | |||
1290 1291 1292 1293 1294 1295 1296 | CREATE TABLE sqlite_stat4(tbl,idx,nEq,nLt,nDLt,sample); </pre></blockquote> <p>There are usually multiple entries in the sqlite_stat4 table for each index. The sqlite_stat4.sample column holds the content of an index entry in the [record format]. The index entry stored is taken from the index identified by sqlite_stat4.idx and sqlite_stat4.tbl. | < < < | 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 | CREATE TABLE sqlite_stat4(tbl,idx,nEq,nLt,nDLt,sample); </pre></blockquote> <p>There are usually multiple entries in the sqlite_stat4 table for each index. The sqlite_stat4.sample column holds the content of an index entry in the [record format]. The index entry stored is taken from the index identified by sqlite_stat4.idx and sqlite_stat4.tbl. The sqlite_stat4.nEq column holds a list of integers where the K-th integer is the approximate number of entries in the index whose left-most K columns exactly match the K left-most columns of the sample. The sqlite_stat4.nLt holds a list of integers where the K-th integer is the approximate number of entries in the index whose K left-most columns are collectively less than the K left-most columns of the sample. |
| ︙ | ︙ |