SQL SERVER – Find Statistics Update Date – Update Statistics

added by pinaldave
1/28/2010 12:00:09 PM

11 Kicks, 300 Views

Statistics are one of the most important factors of a database as it contains information about how data is distributed in the database objects (tables, indexes etc). It is quite common to listen people talking about not optimal plan and expired statistics. Quite often I have heard the suggestion to update the statistics if query is not optimal. Please note that there are many other factors for query to not perform well; expired statistics are one of them for sure.