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

Pushpendra Singh

Total Post:240

Points:1200
Posted by  Pushpendra Singh
 2969  View(s)
Ratings:
Rate this:
  1. Pushpendra Singh

    Post:240

    Points:1200
    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!