/ History for test/analyze5.test
Login

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

History for test/analyze5.test

2019-08-08
15:24
[fa513195] part of check-in [1e17ea2f] Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 7874)
2013-08-12
20:14
[765c4e28] part of check-in [cca8bf43] If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. (check-in: [cca8bf43] user: dan branch: sqlite_stat4, size: 8331)
2013-08-10
19:08
[96ac783a] part of check-in [3a5e8ab7] Add the rowid field to the end of sample records stored in the sqlite_stat4 table. (check-in: [3a5e8ab7] user: dan branch: sqlite_stat4, size: 7854)
2013-08-03
20:24
[e3eece09] part of check-in [2beea303] Begin adding experimental sqlite_stat4 table. This commit is buggy. (check-in: [2beea303] user: dan branch: sqlite_stat4, size: 7783)
2013-06-11
01:50
[3e57f192] part of check-in [e612664a] Handle virtual tables correctly when using logarithmic costs. Fixes to test cases. (check-in: [e612664a] user: drh branch: nextgen-query-plan-logcost, size: 7619)
2011-08-13
19:35
[71335466] part of check-in [89b2f708] 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 branch: stat3-enhancement, size: 7542)
2011-08-03
01:07
[f6c25001] part of check-in [c8ba8855] Adjust the output row estimating logic when using STAT2. (check-in: [c8ba8855] user: drh branch: query-planner-tweaks, size: 8047)
2011-04-08
21:35
[1de8d66b] part of check-in [543f75a6] Always make sure the left-hand side of the IS NOT NULL operator is a simple column, not a general expression, before applying the IS NOT NULL query optimization. (check-in: [543f75a6] user: drh branch: trunk, size: 8047)
2011-03-17
01:34
[adc89b92] part of check-in [23531768] Enhances to the query planner such that "x IS NULL" constraints take the STAT2 statistics into account, just like "x=VALUE" constraints. (check-in: [23531768] user: drh branch: trunk, size: 7945)
2011-02-10
00:08
[0618d2fe] part of check-in [878da276] Refactor the cost function in the query planner. Give extra cost (thus reduce likelihood of selection) to full table scans. (check-in: [878da276] user: drh branch: trunk, size: 6583)
2011-01-28
03:13
[18659612] part of check-in [a2a9f640] Reactivate the analyze5.test script. (check-in: [a2a9f640] user: drh branch: stat2-enhancement, size: 6583)
2011-01-24
17:46
[12df6def] part of check-in [31fcc706] Restructuring and generalizing analyze5.test. The whole script is currently disabled and will need to be reenabled prior to merging with trunk. (check-in: [31fcc706] user: drh branch: stat2-enhancement, size: 11298)
2011-01-21
18:18
[c19fe600] part of check-in [c82cb9c0] Adjustments to the result row estimator for the IN operator so that it gives the same estimates as the equivalent OR operator. Test cases for the same. (check-in: [c82cb9c0] user: drh branch: stat2-enhancement, size: 9901)
2011-01-20
20:36
[b2139886] part of check-in [c7b59afa] Update ANALYZE test cases to check out the use of histograms for equality constraints. (check-in: [c7b59afa] user: drh branch: stat2-enhancement, size: 8978)
16:52
[b6bd2e4f] part of check-in [6bfc5c69] Use histogram data to improve the row-count estimates on equality constraints. (check-in: [6bfc5c69] user: drh branch: stat2-enhancement, size: 6888)
02:56
[18987796] part of check-in [2cd374cd] The first of a planned series of enhancements to the query planner that enable it to make better use of sqlite_stat2 histograms when the table has many repeated values. (check-in: [2cd374cd] user: drh branch: stat2-enhancement, size: 6560) Added