Jan 17 2008
JOIN_BY_SQL Revisited
For the past several years I have included notes about the JOIN_BY_SQL parameter now available for universe designers. The short definition: instead of documents having multiple SQL passes with a join or synchronize option, this parameter asks the database to do the work instead. I have stated in more than one presentation that we saw major performance improvements by using this feature. Now I have to back-track on that just a bit. 🙂
