On Tue, May 29, 2012 at 7:33 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > On 5/29/2012 8:21 PM, Charles Samuels wrote: >> Is this a planned feature? > > > Well, it's not a feature, it's a lack thereof. The query planner is not > specifically looking for this particular optimization opportunity - probably > because such situations are uncommon and are not worth the time looking for. > Your question seems to suggest that optimizations magically happen by > themselves unless someone specifically writes code to block them; in > reality, it's the other way round.
Actually, anytime you have VIEWs that join table sources you can benefit from this optimization. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users