On Mon, Jun 27, 2011 at 2:49 AM, Cecil Westerhof <cldwester...@gmail.com>wrote:

> When giving:
>    select * from sqlite_stat1;
> I get:
>    tbl|idx|stat
>    utilities|sqlite_autoindex_utilities_2|67 1
>    utilities|sqlite_autoindex_utilities_1|67 1
>    categories|sqlite_autoindex_categories_1|4 1
>    weights|sqlite_autoindex_weights_1|228 57 1
>
> I am curious about the stat field. The first value seems the number of
> records (but could also be the last distributed key), the last could be the
> lowest key in the table. Is this correct?
>

http://www.sqlite.org/src/artifact/a425d62e8?ln=309-325



> But when there are three values –weights–, what is the meaning of the
> middle
> value?
>
> --
> Cecil Westerhof
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to