> REINDEX does *not* update the stats. You must run ANALYZE separately.
> May I ask why you are running REINDEX? Sure. We issue new releases of our application about every 3 months. With some of these, we update the schema of the underlying DB. And with some of these schema updates, we have changed the collation sequence (typically added or removed collation). _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
