Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from horacio zapettini on Sep 26 at 1:46 PM May I suggest use hashed tables instead of binary search? You'd get faster performance. ;)
| | | ---------------Original Message---------------
From: Martin Buckley
Sent: Wednesday, September 26, 2012 1:25 PM
Subject: Write Blank if No Email Address Exists
Writing a left join with 5 tables is going to be brutal on performance.
You are better bringing the tables into memory (with ABAP) on at the most 3 tables in the join, then use binary search and sort to link the data. This would of course consume more memory on the box.
Martin Buckley P. Eng.
Solution Architect |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
