[Database] Database statistics management #386
Description
Overview
The SQLite database query plans are sensitive to the distribution/profiles of data in the tables. As such, SQLite can generate statistics using the analyze operation. There is also a command pramgma optimize which has intelligent statistics refresh. Given that the distributions of data should be relatively static, we should consider embedding statistics in the node binary via a database migration. This will allow optimal performance from Genesis without the user having to generate statistics themselves. Furthermore, we should consider if we add a task on a timer for running pragma analyze - I'm uncertain if this will be required.