Execution plans

The optimizer uses the following statistics to determine the optimal execution plan for queries:
  • The number of rows in the table
  • The number of unique or distinct values of each column
  • The number of NULLs in each column
  • The minimum and maximum of each column

For the optimizer to create the best execution plan that results in the best performance, it must have the most up-to-date statistics.