/ Check-in [89b2f708]
Login

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

Overview
Comment:Further testing and bug fixing for sqlite_stat3. Added the Index.avgEq field to index statistics. Fixed several problems in the query planner associated with stat3.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | stat3-enhancement
Files: files | file ages | folders
SHA1: 89b2f70884cad0abdf4c66cb64ecddb2820ded74
User & Date: drh 2011-08-13 19:35:19
Context
2011-08-15
12:02
Fix a couple of typos in comments in analyze.c. check-in: ae31dc67 user: dan tags: stat3-enhancement
2011-08-13
19:35
Further testing and bug fixing for sqlite_stat3. Added the Index.avgEq field to index statistics. Fixed several problems in the query planner associated with stat3. check-in: 89b2f708 user: drh tags: stat3-enhancement
15:25
Add the sqlite_stat3.nDLT field. Use an linear congruence PRNG to choose which samples to select from among those with the same nEq field. check-in: 1dcd2428 user: drh tags: stat3-enhancement
Changes
Unified Diffs Side-by-Side Diffs Patch

Changes to src/analyze.c.

Changes to src/build.c.

Changes to src/sqliteInt.h.

Changes to src/where.c.

Changes to test/analyze.test.

Changes to test/analyze3.test.

Changes to test/analyze5.test.

Changes to test/analyze7.test.

Changes to test/dbstatus.test.

Changes to test/stat3.test.

Changes to test/unordered.test.