Home > IT Answers > SQL Server > What are the query optimization techniques used in SQL 2000?
Gomsbk
35 pts.
 What are the query optimization techniques used in SQL 2000?
SQL Server 2000, SQL Server 2000 queries, SQL Server Query, SQL Server query optimization
What are the query optimization techniques used in SQL?

Software/Hardware used:
SQL server 2000
ASKED: August 24, 2010  5:22 PM
UPDATED: August 28, 2010  7:34 AM
RELATED QUESTIONS
Answer Wiki:
That would be indexing and using the execution plan to find problems in the query.
Last Wiki Answer Submitted:  August 26, 2010  3:43 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

This question sounds like homework.

Gomsbk – if you can explain the purpose of your question (other than “homework”) there is a lot to how query optimization is done inside the database engine.

Kccrosser
 3,830 pts.
 

like indexing,aggregation,early selection,etc what are the optimizations available in SQL?

Gomsbk
 35 pts.