When AUTO CREATE STATISTICS is set at OFF , a manual process must be set up to create statistics. Normally I have AUTO CREATE STATISTICS at ON. This means the SQL Query Optimizer creates the statistics on individual columns for cardinality improvement.