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