Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix typos in the format description comment of analyze.c. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | stat3-trunk |
| Files: | files | file ages | folders |
| SHA1: |
74e27fad339a2d7899c1f42805e61512 |
| User & Date: | drh 2011-09-23 13:25:03 |
Context
|
2011-09-23
| ||
| 13:59 | Testability enhancements. (check-in: be44928c user: drh tags: stat3-trunk) | |
| 13:25 | Fix typos in the format description comment of analyze.c. (check-in: 74e27fad user: drh tags: stat3-trunk) | |
|
2011-09-22
| ||
| 20:52 | Remove the restriction on the number of entries per index in sqlite_stat3. (check-in: 374343c8 user: drh tags: stat3-trunk) | |
Changes
Changes to src/analyze.c.
90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 |
** the sqlite_stat2 table. There are multiple entries for each index. ** The idx column names the index and the tbl column is the table of the ** index. If the idx and tbl columns are the same, then the sample is ** of the INTEGER PRIMARY KEY. The sample column is a value taken from ** the left-most column of the index. The nEq column is the approximate ** number of entires in the index whose left-most column exactly matches ** the sample. nLt is the approximate number of entires whose left-most ** column is less than the same. The nDLt column is the approximate ** number of distinct left-most entries in the index that are less than ** the same. ** ** Future versions of SQLite might change to store a string containing ** multiple integers values in the nDLt column of sqlite_stat3. The first ** integer will be the number of prior index entires that are distinct in ** the left-most column. The second integer will be the number of prior index ** entries that are distinct in the first two columns. The third integer ** will be the number of prior index entries that are distinct in the first |
| | |
90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 |
** the sqlite_stat2 table. There are multiple entries for each index. ** The idx column names the index and the tbl column is the table of the ** index. If the idx and tbl columns are the same, then the sample is ** of the INTEGER PRIMARY KEY. The sample column is a value taken from ** the left-most column of the index. The nEq column is the approximate ** number of entires in the index whose left-most column exactly matches ** the sample. nLt is the approximate number of entires whose left-most ** column is less than the sample. The nDLt column is the approximate ** number of distinct left-most entries in the index that are less than ** the sample. ** ** Future versions of SQLite might change to store a string containing ** multiple integers values in the nDLt column of sqlite_stat3. The first ** integer will be the number of prior index entires that are distinct in ** the left-most column. The second integer will be the number of prior index ** entries that are distinct in the first two columns. The third integer ** will be the number of prior index entries that are distinct in the first |