Join optimization and dynamic programming
Example
The query is something like this:
select ...
from A join B using (...)
join C using (...)
join D using (...)
where A.x = 1
and B.y between 10 and 20
and C.z > 1000
and C.m < -1
and D.w between "xya" and "xyc"
|