SQL SERVER – Puzzle – Statistics are not Updated but are Created Once
- by pinaldave
After having excellent response to my quiz – Why SELECT * throws an error but SELECT COUNT(*) does not?I have decided to ask another puzzling question to all of you.
I am running this test on SQL Server 2008 R2. Here is the quick scenario about my setup.
Create Table
Insert 1000 Records
Check the Statistics
Now insert 10 times more 10,000 indexes…