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 
Ratings:
 1 Answer(s)
  2593  View(s)
Rate this:

Pushpendra Singh

Total Post:241

Points:1205
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