On Tue, Dec 13, 2016 at 9:56 AM, Simon Slavin <slav...@bigfraud.org> wrote:
> > On 13 Dec 2016, at 3:53pm, Paul Egli <e...@sourcegear.com> wrote: > > > Well if i am missing something, i still cannot see it. > > > > Based on these quotes in the docs, i assume that a NULL in the child > table > > means that it does not have a parent. > > You are correct. I missed that. > > So yes, the original poster was correct, and using an index which left out > the NULL key values would lead to the right results. Should be possible to > use that for an optimization case. I suppose it might lead to quite a > saving in filespace for some tables. > Great. Just to clarify, SQLite will already use "alternateChildIndex1" from the example? Or just that it would be possible as an enhancement request? Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users