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