On 2017/12/20 7:27 PM, Simon Slavin wrote:
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. //...
Quite right - but...
With really big in-use tables, I often find myself dropping indexes,
doing bulk deletes/inserts then recreating the Indexes and doing an
Analyze - Not to mention the fact that we often teach others to do this
(as is the case in a recent thread), so since CREATE INDEX must walk the
table already, so perhaps there does exist a real niche for CREATE
ANALYZED INDEX ....;
That said, I've never known Analyze to consume significant time (but
that might be due to many things), so not sure the savings will be
significant for the general case.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
