Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|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|
|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|
|18:17||If an "INSERT INTO ... SELECT" can use the xfer optimization, pass the OPFLAG_BULKCSR hint to btree cursors used to update indices. This results in a tighter key packing. check-in: 087af29e user: dan tags: trunk|
|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|
|02:36||Progress toward using the iScanRatio information on indices. Many tests are still failing. check-in: 6c352edb user: drh tags: index-scan-rate|
|19:21||Experimental branch allowing different postulated scan rates for each index. check-in: d59d97b0 user: drh tags: index-scan-rate|
|15:39||The sqlite3FixInit() routine cannot fail. So change the return type from "int" to "void". check-in: 500c5932 user: drh tags: trunk|