/ Check-in [1b95544f]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
Comment:Add an extra column to a table in analyze9.test to give the planner a little more reason to select an index.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | experimental-costs
Files: files | file ages | folders
SHA1: 1b95544f84bf83c28cc15f6d0690fdf8a6bb3941
User & Date: dan 2014-04-28 12:08:23
Context
2014-04-28
15:11
Update unordered.test to take into account for the fact that SQLite now prefers a full-table scan over a non-covering index scan that visits a large percentage of the table rows. check-in: 20f468df user: dan tags: experimental-costs
12:08
Add an extra column to a table in analyze9.test to give the planner a little more reason to select an index. check-in: 1b95544f user: dan tags: experimental-costs
10:00
Update test script analyze3.test to account for the fact that SQLite now prefers a full-table scan over a non-covering index scan that visits a large percentage of the table rows. check-in: 35f46a55 user: dan tags: experimental-costs
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to test/analyze9.test.

   562    562   #-------------------------------------------------------------------------
   563    563   # Check that affinities are taken into account when using stat4 data to
   564    564   # estimate the number of rows scanned by a rowid constraint.
   565    565   #
   566    566   drop_all_tables
   567    567   do_test 13.1 {
   568    568     execsql {
   569         -    CREATE TABLE t1(a, b, c);
          569  +    CREATE TABLE t1(a, b, c, d);
   570    570       CREATE INDEX i1 ON t1(a);
   571    571       CREATE INDEX i2 ON t1(b, c);
   572    572     }
   573    573     for {set i 0} {$i<100} {incr i} {
   574    574       if {$i %2} {set a abc} else {set a def}
   575    575       execsql { INSERT INTO t1(rowid, a, b, c) VALUES($i, $a, $i, $i) }
   576    576     }