We are running SQL Server 2008R2 ENT and kept auto update stats and auto create stats enabled. We identified a performance issue and added the required index(es) in full . However performance did not improve. I then ran the query through the Database Engine Tuner which identified some statistics were missing . What I don't understand is that the indexes were created , but the required statistics were not .