title: Why auto update statistics are not efficient to improve the performance
body: <p>We have a DB of size 1257GB having 100+ objects with hourly transactions (Insert and update). </p>
  
  <p>We have set <code>Auto Update statistics:True</code> and <code>Auto Update statistics asynchronously : False</code>. </p>
  
  <p>When we trigger the queries to fetch the data it's taking long time. But when we manually execute <code>SP_UpdateStats</code>, the same query is taking very less time to fetch the same amount of data. </p>
  
  <p>Please let me know whether we need to update the stats on regular basis? And what are the advantages and disadvantages of using <code>EXEC SP_UpdateStats</code>?</p>
  
  <p>Windows server 2012R2 and SSMS2014.</p>