On 10/15/17, korablev <kitn...@gmail.com> wrote: > > Moreover, if .selecttrace and .wheretrace options are enabled, we can > notice, that for without rowid tables planer doesn't even take into account > SCAN TABLE plan:
[...] > skip: * 0.01.00 t1._1 0 f 00240 N 0 cost > 0,121,98 This is the SCAN TABLE plan for the WITHOUT ROWID example. It is considered, but is immediately rejected, since the estimated cost is very slightly higher than the estimated cost of using the t1b index. It might not be computing a good estimate for the cost of doing a full table scan on a WITHOUT ROWID table. I need to review that computation. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
