Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/analyze2.test
|
2011-08-06
| ||
| 01:22 | Fix a compiler warning when STAT2 is off. More test cases. Fix legacy tests to deal with the new STAT2 logic. file: [b2c53cf7] check-in: [7e914aa9] user: drh branch: query-planner-tweaks, size: 18073 | |
|
2011-08-05
| ||
| 21:13 | Add a column to the sqlite_stat2 table that contains the number of entries with exactly the same key as the sample. We do not yet do anything with this extra value. Some tests in analyze2.test are failing. file: [6a5c1420] check-in: [eb434228] user: drh branch: query-planner-tweaks, size: 18063 | |
|
2011-02-12
| ||
| 14:23 | Fix the expected output on tests so that it corresponds to the new query planner results. All of veryquick.test is now passing with SQLITE_ENABLE_STAT2. file: [ea3df826] check-in: [f2a8b5cc] user: drh branch: branch-3.7.2, size: 18220 | |
|
2011-01-28
| ||
| 01:57 | Change the weighting of binary searches on tables to 1/10th the cost of a search on an index. Change the assumed reduction in search space from a indexed range constraint from 1/3rd to 1/4th. Do not let the estimated number of rows drop below 1. file: [8f2b1534] check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 18040 | |
|
2011-01-20
| ||
| 02:56 | 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. file: [f45ac8d5] check-in: [2cd374cd] user: drh branch: stat2-enhancement, size: 17979 | |
|
2010-11-15
| ||
| 16:12 | Change some test cases to account for the new EXPLAIN QUERY PLAN output. file: [3bde8f08] check-in: [88a854e1] user: dan branch: trunk, size: 17978 | |
|
2010-06-22
| ||
| 13:46 | Some changes to test scripts related to codec enabled versions of sqlite. file: [59dac6c3] check-in: [85dd51a7] user: dan branch: trunk, size: 15992 | |
|
2009-09-21
| ||
| 16:34 | Fix compilation with both OMIT_UTF16 and ENABLE_STAT2 defined. Ticket [56928bd084]. file: [a2ad7b0a] check-in: [cd850d49] user: dan branch: trunk, size: 15827 | |
|
2009-08-20
| ||
| 16:11 | Change the code that collects samples for sqlite_stat2 so that the first sample taken is the (nRow/(2*SQLITE_INDEX_SAMPLES))th entry in the index, where nRow is the total number of index entries. file: [297d3d63] check-in: [cbfe6e9d] user: dan branch: trunk, size: 15725 | |
|
2009-08-19
| ||
| 15:34 | Add some tests that use the sqlite_stat2 table in shared-cache mode. file: [f3c0944b] check-in: [29cafcfd] user: dan branch: trunk, size: 15721 | |
| 14:34 | Clean up sqlite_stat2 related code. Add test cases. file: [eb66cbd9] check-in: [aa728e06] user: dan branch: trunk, size: 12567 | |
| 08:18 | Add the SQLITE_ENABLE_STAT2 macro. If this is not defined at build-time, the stat2 table is not created, populated, or used. file: [f58acc55] check-in: [362665e8] user: dan branch: trunk, size: 7352 | |
|
2009-08-18
| ||
| 16:24 | Change the sqlite_stat2 schema to be more flexible. file: [30987f59] check-in: [ded9dec6] user: dan branch: trunk, size: 7345 Added | |