Documentation Source Text

Check-in [d4c54c7ebe]
Login

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.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: d4c54c7ebeaf4218ce9e86fa3a1d5526cc728232
User & Date: drh 2016-03-02 13:16:49.632
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
Unified Diff Ignore Whitespace Patch
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.