On 11/8/17, Peter Da Silva <peter.dasi...@flightaware.com> wrote: > On 11/8/17, 8:20 AM, "sqlite-users on behalf of Richard Hipp" > <sqlite-users-boun...@mailinglists.sqlite.org on behalf of d...@sqlite.org> > wrote: >> The technical reason for this is that, from the point of view of the query >> planner, a WITHOUT ROWID table is really a covering index > > So basically the whole table is stored inline with the primary key index?
That's the basic idea, yes. -- 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