Explicit sort vs. Sort in the join stage?
Posted: Wed Mar 15, 2006 7:00 pm
Helloo Guys/Girls,
I have a simple question, when you are joining two tables by using join stage, do you have to sort and partition the tables by using a sort stage or is it enough to click on the auto box inside the join stage. in the reference book it says it is enough to just click on the auto check box and it will automatically sort by using the key fields and partition the file.
if it is enough which one is better? a person told me it is not a good idea to use the auto click box inside the join stage, it can give wrong results, poor performance etc, but I don't completely agree with him. just wanted to make sure here.
p.s. I am new to DS PX and since I don't have a parallel extender I cannot test by myself. just trying to learn by reading only , for now.
thanks in advance
I have a simple question, when you are joining two tables by using join stage, do you have to sort and partition the tables by using a sort stage or is it enough to click on the auto box inside the join stage. in the reference book it says it is enough to just click on the auto check box and it will automatically sort by using the key fields and partition the file.
if it is enough which one is better? a person told me it is not a good idea to use the auto click box inside the join stage, it can give wrong results, poor performance etc, but I don't completely agree with him. just wanted to make sure here.
p.s. I am new to DS PX and since I don't have a parallel extender I cannot test by myself. just trying to learn by reading only , for now.
thanks in advance