How to increase the JOIN stage performance

[HariD]

I have so many JOIN stages in my job then i want to improve the performance of the job.All join stages partition type is Auto is there result while setting the any other partition technique..

Any answer would be appreciated.

[ArndW]

Joins want sorted data, so it is best to put in your own explicit sort stages and, when not necessary, mark sort key columns as "don't sort, previously sorted". Partitioning and repartitioning must be done on the join keys.

[ray.wurlod]

Investigate your logic - see if you can eliminate any of the sorts. As Arnd noted, using a Sort stage to avoid re-sorting is often useful.