Lets say I have a database FOO for which I created a snapshot (named FOO_snap). Now I'll run thousands of queries on this DB. After that I will revert DB to FOO_snap. Will I lose all of the statistics which were created for these thousand of queries?
Yes you would:
The original source database is overwritten by the reverted database, so any updates to the database since the snapshot's creation are lost.
The metadata of a reverted database is the same as the metadata at the time of the snapshot.
Quotes from Revert a Database to a Database Snapshot in the MSDN Library.
Further to Sporri's answer - you can check this if you are using SSMS.
To view a database snapshot on a server:
- In Object Explorer, connect to the instance of the Microsoft SQL Server >Database Engine and then expand that instance.
- Expand Databases.
- Expand Database Snapshots, and select the snapshot you want to view.
When you do this, it gives you the list of objects that are included in the Snapshot, as it would with a normal database (right down to Statistics etc.)