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. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users