On 25 Nov 2017, at 1:15pm, curmudgeon <tam118...@hotmail.com> wrote:
> Given a select where a 'base table' is attached to lookup tables > how can I determine which of the lookup tables can be removed from the table > such that > > select BaseTbl.RowID from ... where ... order by ... > > will find the set of records that represents the original query. That optimization could be done at the level of the SQL engine. You wouldn’t want to do it inside your own code since that would make your code extremely complicated. So just execute the query without trying to optimize it and see what happens. Does it run fast enough for your users ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
