0 - 2 of 2 tags for dbql performance comparison

I suppose the first one as all the columns in the join are the UPI of both the tables and statistics are also collected on the UPI.


Does your data warehouse contain organizational hierarchies, bills-of-material, or transportation networks? If so, you likely have a good candidate business problem for recursive SQL...