drh
68262d85ec
New test case for ticket [b899b6042f97f52d].
...
FossilOrigin-Name: 9d91ee5ee3f316a8804b02eb3c34b175b8f87b28c22df56f481af708c54e297c
2017-09-11 23:46:59 +00:00
drh
7e6f980bd4
Proposed fix for ticket [b899b6042f97f5]
...
FossilOrigin-Name: c7f9f47b239fdd99b555fb0a31eb82b22dbe6c821f1612d67a0d6a822288d9f7
2017-09-04 00:33:04 +00:00
dan
c456a76fb3
When generating individual loops for each ORed term of an OR scan, move any
...
constant WHERE expressions outside of the loop, as is done for top-level
loops.
FossilOrigin-Name: e4a022be4b069b08cfdfda5295461676b99d28e17bbbedfbcb362dec69de59bd
2017-06-22 16:51:16 +00:00
drh
f46af73720
If the cost of two whereLoop objects is the same in every way except that
...
one has fewer expected output rows than the other, then choose the one with
fewer output rows.
FossilOrigin-Name: 79e458ef7acfddbc189163e3e958da529becb130
2013-08-30 17:35:44 +00:00
drh
fd5874d23d
Add the "queryplanner" test permutation. Continuing refinements to NGQP.
...
FossilOrigin-Name: 25e2cde105a19293bdb9c001b48624e5d7f8c4e5
2013-06-12 14:52:39 +00:00
drh
782d68a4cd
Try to take into account the cost of inner loops when selecting which table
...
of a join to use for the outer loop.
FossilOrigin-Name: 942556342a332b04a11169bb04f387d741ef9488
2012-11-09 17:59:26 +00:00