How to enable statistics in SQL Server

Enable statistics in an SQL Server database to optimize the Query Processor.

1. Access the properties of the database.
   1. Right-click in the database.
   2. Select the option Properties.
2. Enable the database statistics.
   1. Select the page Options.
   2. Enable the database statistics.
      • Auto Create Statistics: Select True.
      • Auto Update Statistics: Select True.