/ Timeline
Login

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

16 check-ins using file test/pragma.test version de128f02

2013-10-08
20:42
Rollback some of the previous changes in the branch such that the estimated row sizes are now only used as a tie-breaker for index scans. check-in: 65553ff3 user: drh tags: row-size-est
20:01
Use #ifdefs to omit unused code in the columnType() routine depending on compile-time options. check-in: 3fd5e332 user: drh tags: row-size-est
18:40
Further refinement of the idea of multiplying run-time cost estimates by the estimated row size. check-in: 18bd6ba9 user: drh tags: row-size-est
2013-10-07
17:32
Multiply all cursor step cost estimates by the estimated size of the row in bytes, in order to get the query planner ot make use of estimated row sizes. This check-in uses magic numbers in a few places (for example, estimates of the size of output rows) and needs lots of refinement. Consider this a proof-of-concept only. check-in: cb34cfe5 user: drh tags: row-size-est
16:53
Try to remember statistics from ANALYZE using LogEst instead of u64. Leaf check-in: 8e78557a user: drh tags: log-stats
10:48
Merge bug fixes from trunk. check-in: 1d7b2dc0 user: drh tags: row-size-est
2013-10-06
22:12
Accept the sz=N parameter on table-only lines of sqlite_stat1. check-in: e9e932aa user: drh tags: row-size-est
2013-10-05
20:18
Fix an issue in the test8.c test module that arises because of the change to PRAGMA index_list(). Remove an unused local variable. check-in: 029430c5 user: drh tags: row-size-est
19:18
Completely remove the iScanRatio field. The PRAGMA index_list(TABLE) command shows the estimated row size in the forth column. It also generates a row for the table with an index name of NULL. The query planner still does not take row size estimates into account - that is the next step. check-in: 8b4aa0c7 user: drh tags: row-size-est
18:32
Improvements to the LogEst command-line tool used to convert between ordinary numbers and the LogEst representation. check-in: 5252aeb6 user: drh tags: row-size-est
18:16
Begin an experimental refactoring to estimate the average number of bytes in table and index rows and to use that information in query planner. Begin by renaming WhereCost to LogEst and making that type and its conversion routines available outside of where.c. check-in: 66c4a251 user: drh tags: row-size-est
02:56
In the index_list pragma, make sure the "r" column is the same on output as it was on input in the sqlite_stat1 table. Closed-Leaf check-in: de78250a user: drh tags: index-scan-rate
2013-10-04
20:39
Merge trunk changes. check-in: c6ac80ed user: drh tags: index-scan-rate
18:29
Further refinements of the index scanning speed logic. check-in: e5d9371d user: drh tags: index-scan-rate
15:58
Fix test cases so that they work when the query planner uses index size estimates to determine whether or not to try an covering index scan. check-in: 2f394de8 user: drh tags: index-scan-rate
15:30
Improved estimates of the relative speed of index scans based on declared datatypes of columns in the table. Add "r" column to PRAGMA index_info, showing the estimated relative scan rate. check-in: 07462bb6 user: drh tags: index-scan-rate