Quote Originally Posted by suneeshsnair
True but doesnt improve the performance time!
Use 10046 trace event to get more info on wait events.

The sort area size or temp file may not be set up correctly.

Tamil