On 20 Dec 2017, at 5:19pm, David Raymond <david.raym...@tomtom.com> wrote:
> I have often thought that a "create analyzed index" statement would be nice > addition though to do the two at the same time. Perhaps not as useful as you might think, because most people create indexes while their tables are empty. ANALYZE gathers information about the data in your table. For instance, the difference between an 'inStock' column which has just two values 'yes' and 'no', and a 'surname' column in which almost every value is different. To do this, it needs to be run after the table has data. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
