What exactly is saved in SQL Server Statistics? When they get updated? Is SQL Server itself is taking care of them?
- by Pritesh
I have been working with SQL Server as a Developer a while.
One thing I learnt is SQL Server manages Statistics which help Engine to create optimized execution plan.
I could not figure out what exactly is stores in Statistics? (I read it saves Vector, but what Vector?)
When/In which scenario SQL Server updates Statistics?
How/why some time they go out of sync (old Statistics)
In case of old Statistics is a manual DBA/Developer intervention is required or SQL Server Will get them updated.
As a DBA/Developer how to find out if Statistics OLD? What should we do?