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.