/ Check-in [26565b89]
Login

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

Overview
Comment:The shell does not output the sqlite_stat1 table on .dump or .schema. The ANALYZE command now gathers statistics on tables that have only a single index because this sometimes helps when reordering tables in a join. (CVS 2686)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 26565b8931419031f9a8dd3947e1e2bd23ccbff2
User & Date: drh 2005-09-10 22:40:54
Context
2005-09-11
02:03
The ".dump" command from the shell correctly saves the state of the sqlite_sequence and sqlite_stat1 tables, if they exist. Ticket #1419. (CVS 2687) check-in: 3f191cf4 user: drh tags: trunk
2005-09-10
22:40
The shell does not output the sqlite_stat1 table on .dump or .schema. The ANALYZE command now gathers statistics on tables that have only a single index because this sometimes helps when reordering tables in a join. (CVS 2686) check-in: 26565b89 user: drh tags: trunk
16:46
Add the experimental EXPLAIN QUERY PLAN diagnostic capability. (CVS 2685) check-in: 986efb7b user: drh tags: trunk
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/analyze.c.

Changes to src/shell.c.

Changes to test/analyze.test.