Why can a "group by" or "order by" clause be expensive to process

Question

Pushpendra Singh · Answer

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.

interview

Why can a "group by" or "order by" clause be expensive to process

Can you answer this question?

1 Answers