Recently I had presented a session on SSRS 2008 R2 enhancements. As part of that I explained about LOOKUP function and its way of working. There was a question while presenting this feature.
From performance perspective, what are the advantages of LOOKUP function over conventional implementation of JOINING the lookup tables in stored procedure itself.
I tried explaining that, it enables to make best utilization of resources in scaleout environment because the logic of JOIN evaluation has been shifted to Report Server than a database server. Some how the participants were not convinced.
I would request experts to comment on this and help me in understanding whether my evaluation is correct or is there anything I am missing over here during my explanation.
Please help.Phani Note: Please mark the post as answered if it answers your question.
View Complete Post