Our join expression constant folding bails out if it sees a candidate number of rows that exceeds a threshold. However, it does this testing as it goes, before it applies equality constraints. Applying the equality constraints as one goes could dramatically reduce the number of candidates, and generally make the process faster as well as less likely to fail out.
Our join expression constant folding bails out if it sees a candidate number of rows that exceeds a threshold. However, it does this testing as it goes, before it applies equality constraints. Applying the equality constraints as one goes could dramatically reduce the number of candidates, and generally make the process faster as well as less likely to fail out.