Why Can A "group By" Or "order By" Clause Be Expensive To Process?

1.	Why Can A "group By" Or "order By" Clause Be Expensive To Process?
Answer» 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. 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»

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.

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.

Discussion

No Comment Found

Related InterviewSolutions

What's The Maximum Size Of A Row?
What Type Of Index Will Get Created After Executing The Below Statement?
What Are Defaults? Is There A Column To Which A Default Can't Be Bound?
What Is Group By?
What Is A Sql View?
Why Can A "group By" Or "order By" Clause Be Expensive To Process?
What Types Of Index Data Structures Can You Have?
What Is A "constraint"?
What Is "normalization"? "denormalization"? Why Do You Sometimes Want To Denormalize?
What Are The Tradeoffs With Having Indexes?

Why Can A "group By" Or "order By" Clause Be Expensive To Process?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment