/ Check-in [c69c3e21]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add an option to generate stat1 data based on a subset of the user database table contents to sqlite3_expert.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | schemalint
Files: files | file ages | folders
SHA3-256: c69c3e21db6e141f7e24226c6432f2ed31fe5f177bd23781915871f8600ee56a
User & Date: dan 2017-04-20 09:54:04
Context
2017-04-20
16:18
Avoid adding INTEGER PRIMARY KEY columns to candidate indexes. check-in: 4577fea5 user: dan tags: schemalint
16:08
Avoid creating a temp table in the user database in the sqlite3_expert code. Trouble is, this makes sampling for stat1 data much slower. check-in: c62e3582 user: dan tags: schemalint-failure
09:54
Add an option to generate stat1 data based on a subset of the user database table contents to sqlite3_expert. check-in: c69c3e21 user: dan tags: schemalint
2017-04-18
20:10
Have sqlite3_expert_analyze() populate the sqlite_stat1 table before running queries through the planner for the second time. check-in: a157fcfd user: dan tags: schemalint
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to ext/expert/expert.c.

Changes to ext/expert/sqlite3expert.c.

Changes to ext/expert/sqlite3expert.h.