Columns With No Statistics
Columns With No Statistics
These occur most frequently in two scenarios
- Someone turned auto-create stats off for a database
- An indexed view was called without the NOEXPAND hint
In either case, you could end up with some really weird performance issues. Some 3rd party applications advise you to turn auto-create stats off, so check with your vendor if it’s set at the database level.
If you see the warning from indexed views, try using the NOEXPAND hint to prevent the optimizer from expanding the view definition.
