Home > DeveloperSection > Interviews > Why can a "group by" or "order by" clause be expensive to process

Posted on    October-25-2010 12:00 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  2526  View(s)
Rate this:

Pushpendra Singh

Total Post:241

Posted on    November-01-2010 12:00 AM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick