On Thu, May 31, 2012 at 11:25 AM, Jos Groot Lipman <[email protected]> wrote: >> Actually, anytime you have VIEWs that join table sources you >> can benefit from this optimization. > > No, there is only a benefit if the optimization actually finds a table that > can be removed from the join.
When you create a VIEW from a JOIN you have no idea if queries on that VIEW will need the JOIN. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
