locked
SQL Server error in log file RRS feed

  • Question

  • Hello!


    I am seeing these "errors" in my SQL Server log, I understand this won't cause any issues with the database and it is just a notification about the SQL Server Performance Optimizer but wanted to check for second opinion:


    Missing column statistics: NO STATS :([BBDD].[dbo].[table].[Column])


    Please be aware I have replaced the information regarding the database, table and column for privacy purposes, but it actually points to an existing database, table and column.


    Could someone confirm that this error is only a notification and no services will be affected?


    Thanks in advance


    Regards

    Wednesday, October 26, 2016 12:35 PM

Answers

  • The query optimizer notices that there are no statistics on this column. Statistics might help the query optimizer to make a better decision in creating an execution plan.

    Think of it as a suggestion, not an error. You might get better performance with statistics on this column.

    • Marked as answer by Leandro Piedra Wednesday, October 26, 2016 12:38 PM
    Wednesday, October 26, 2016 12:37 PM