The Auto create statistics option causes SQL Server to automatically create single column statistics on any column used in a "where" clause (if that column is not the leading field in an existing index). By collecting these additional statistics, the SQL Server Optimizer has more complete information when determining an execution plan.