What statements allow you to manage statistics in SQL Server 2005 ?

Place the mouse cursor HERE for the answer

Reference: "Statistics Used by the Query Optimizer in Microsoft SQL Server 2005" http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

sp_autostats allow to create update display statistics at object level(index ,table ,statistic object)

---

Secolul XXI ori va fi religios ori nu va fi deloc

Actually the correct answer is CREATE STATISTICS, UPDATE STATISTICS and DROP STATISTICS.

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro