Skip to Content
0
Jul 30, 2016 at 10:02 AM

question on join rank in BODS

1291 Views

Hi all,

i am trying to understand how join ranking option in query designer could help me in the performance optimization in a BODS job.

i have checked various articles on this but still dint understand what actually happens and how this feature could really help.

can anyone please help on this?

let us take an example of 3 tables and below are its row counts.

T1 - 100 rows

T2 - 100000 rows

T3 - 1000000000 rows

what might happen if i leave the join rank settigns to default?

what happens if i do a wrong setting like below?

T1 - join rank 10

T2 - join rank 8

T3 - join rank 5