Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from R. N. Wilhite on Sep 26 at 2:57 PM The fact that this is being attempted in query makes that pretty much
irrelevant. There is no such thing as an efficient query. Now, move it to
an ABAP and everything changes.
Neal
| | | ---------------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. __.____._ |   _.____.__ |
