InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 20:41:18 GMT20http://www.sqlservercentral.com/Forums/Topic602194-146-1.aspx[url]http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/[/url]You can't change the frequency. The % of changes that kicks off a stats update is hardcoded. You can update stats manually using UPDATE STATISTICS.Thu, 13 Nov 2008 09:36:07 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic602194-146-1.aspxHi,How does update statistics mechanism work in sql server 2000 and 2005?Does engine collect data in a periodic time? How often it collects? Can i change this period, how?How can i update statistics at the moment?Thanks.Thu, 13 Nov 2008 08:53:21 GMTthinknight