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

Reply via email to