Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Tweaks to the description of the sqlite_stat1 table in the fileformat2 document. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
d4c54c7ebeaf4218ce9e86fa3a1d5526 |
| User & Date: | drh 2016-03-02 13:16:49 |
Context
|
2016-03-04
| ||
| 15:33 | Application note on the default page size change. Updates to the change log. check-in: 954e5c9945 user: drh tags: trunk | |
|
2016-03-02
| ||
| 13:16 | Tweaks to the description of the sqlite_stat1 table in the fileformat2 document. check-in: d4c54c7ebe user: drh tags: trunk | |
|
2016-02-27
| ||
| 14:20 | Include "OR ROLLBACK" among the examples of how to omit statement journals. check-in: 237bf9365d user: drh tags: trunk | |
Changes
Changes to pages/fileformat2.in.
1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 |
the name of the table to which the index belongs.)^ ^(In each such row, the sqlite_stat.stat column will be a string consisting of a list of integers followed by zero or more arguments.)^ ^The first integer in this list is the approximate number of rows in the index. (The number of rows in the index is the same as the number of rows in the table, except for [partial indexes].) ^The second integer is the approximate average number of rows in the index that have the same value in the first column of the index. ^The third integer is the approximate average number of rows in the index that have the same value for the first two columns. ^The N-th integer (for N>1) is the approximate average number of rows in the index which have the same value for the first N-1 columns. ^For a K-column index, there will be K+1 integers in the stat column. ^If the index is unique, then the last integer will be 1. <p>^The list of integers in the stat column can optionally be followed by arguments, each of which is a sequence of non-space characters. ^All arguments are preceded by a single space. |
| | | |
1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 |
the name of the table to which the index belongs.)^ ^(In each such row, the sqlite_stat.stat column will be a string consisting of a list of integers followed by zero or more arguments.)^ ^The first integer in this list is the approximate number of rows in the index. (The number of rows in the index is the same as the number of rows in the table, except for [partial indexes].) ^The second integer is the approximate number of rows in the index that have the same value in the first column of the index. ^The third integer is the number number of rows in the index that have the same value for the first two columns. ^The N-th integer (for N>1) is the estimated average number of rows in the index which have the same value for the first N-1 columns. ^For a K-column index, there will be K+1 integers in the stat column. ^If the index is unique, then the last integer will be 1. <p>^The list of integers in the stat column can optionally be followed by arguments, each of which is a sequence of non-space characters. ^All arguments are preceded by a single space. |