Performance in sort stage

I am running huge amount of data through a sort stage and it is very slow. Is there any option which can increase the performance with in the sort stage?

Questions by chandubmca   answers by chandubmca

Showing Answers 1 - 3 of 3 Answers

manoharkolukula

  • Jan 25th, 2008
 

See if it is orcle db then u can write user def query for sort and remove duplicates in the source itself. and maintaining some key partition teqniques u can improve the performence.

If it is not the case means better go for some key partion teqniques in sort, keeping the same partition which is in prev stage. don't allow the duplicates , remove duplicates and give unique partition key.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions