Processing of "group by" or "order by" clause often requires creation of Temporary tables to process the results of the query. Which depending of the result set can be very expensive.
Liked By
Write Answer
Why can a "group by" or "order by" clause be expensive to process
Join MindStick Community
You have need login or register for voting of answers or question.
Pushpendra Singh
01-Nov-2010