Hi gurus
I wonder if, while creating a DB view, the order of join conditions will affect the overall performance. In my case, i need to join COEP, COBK and TKA01. Actually the join conditions are, in this order:
COEP MANDT = TKA01 MANDT
COEP KOKRS = TKA01 KOKRS
COBK MANDT = COEP MANDT
COBK KOKRS = COEP KOKRS
COBK BELNR = COEP BELNR
To achieve a better performance, may I change the order (up/down or left/right)?
Thank you! <removed by moderator>
Edited by: Thomas Zloch on Jan 19, 2012