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