Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.
|Comment:||Modify the query planner interface so that it always passes in the result set. This is the first step toward adding an optimization that will omit tables from a join that do not contribute to the result.|
|Downloads:||Tarball | ZIP archive | SQL archive|
|Timelines:||family | ancestors | descendants | both | omit-join-table-opt|
|Files:||files | file ages | folders|
|User & Date:||drh 2013-06-21 00:35:37|
|02:05||Attempt to disable inner loops of a join that do not generate output. This does not work, since the inner loops might run zero times and thus inhibit all output. Needs to be enhanced to work only for LEFT JOINs or when we know that the inner loop will always run at least once. check-in: ca839723 user: drh tags: omit-join-table-opt|
|00:35||Modify the query planner interface so that it always passes in the result set. This is the first step toward adding an optimization that will omit tables from a join that do not contribute to the result. check-in: 2c2577e6 user: drh tags: omit-join-table-opt|
|17:32||Add a NEVER() macro and an explanation comment around an unreachable branch in the STAT3 logic. check-in: 604c3c5d user: drh tags: nextgen-query-plan-exp|
Changes to src/select.c.
Changes to src/sqliteInt.h.
Changes to src/where.c.
Changes to test/alter2.test.