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:
01344734
Views:
23
Hi Mike,

> My question is what are the purpose of the statistics?

They contain information about the values in a table, for example, whether you have only a few different values in a column (like the State field in an address record) or many different values (such as Name). This information is for example used when you join two tables. SQL server tries to start the join with the table that returns less records for the join expression.
--
Christof
Previous
Reply
Map
View

Click here to load this message in the networking platform