Skip to Content
0
Former Member
Jan 19, 2012 at 12:23 PM

DB view - join conditions order

96 Views

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