35 pts.
 What are the query optimization techniques used in SQL 2000?
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

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.


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.

 3,830 pts.

 

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

 35 pts.