On Sat, Dec 20, 2025 at 05:49:24PM -0500, Bruce Momjian wrote:
> What Robert is saying in the above paragraph is even more complex ---
> that we might want to use an index on the fact table for a merge join of
> a stage 2 or 3 join, and then do the other joins. How would we detect
> this? Could we run each join on its own and see which ones choose merge
> join, and move them to stage 1?
Thinking some more, how likely would we do a merge join before applying
a restrictive join?
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.