In my previous post, I reviewed the basic logic behind why the Optimizer chooses one join algorithm over another. In this post, I’ll go one step further and discuss what happens when the basic logic for joins is combined with the logic for how UDFs...

I got a question from a customer today related to join algorithms. This is a good, general topic, so I will post a few notes on this in the hopes that it is interesting to anyone out there who doesn’t understand how the costing formulas are put...