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?
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
