Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Benefits of Statistics in SQL 2005
Message
 
 
To
03/09/2008 21:45:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01344709
Message ID:
01344711
Views:
9
The indexes are used to optimize queries. The index statistics are use by SQL Server query processor to determine an execution plan for a query.

>
>I've been playing with the DTA (Database Tuning Advisor) and if I tried to optimize a query it then suggests some recommendations to create indexes and statistics. My question is what are the purpose of the statistics? Will they occupy huge disk space? Are they going to affect the speed on retrieving, updating and inserting data?
>
>
>Thanks in advance....
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform