Sort operations:

Always perform the following checks first before using the sort in the design:

1) Is sort really needed?
2) What is the volume of data going to be sorted?
3) Is data being read from database first and getting sorted in the job? Can we not sort the data in the database and bring sorted data?
4) What are the values set in the system related to Sort stage?

If we give attention to above questions before applying sort then this will help up creating more performant job.