WHY CAN A "GROUP BY" OR "ORDER BY" CLAUSE BE EXPENSIVE TO PROCESS

Pushpendra Singh

Total Post:241

Points:1205
Posted by  Pushpendra Singh
 2834  View(s)
Ratings:
Rate this:
  1. Pushpendra Singh

    Post:241

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

    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.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!