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

Question

Pushpendra Singh · Answer

Processing of andquot;group byandquot; or andquot;order byandquot; 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

Pushpendra Singh

Can you answer this question?

1 Answers

Liked By