Re: when to 'update statistics' ???

In article <5cpsh1$fmr@cssun.mathcs.emory.edu>, Leo_Chen@usc.com.tw writes > > > > > >Hi all: > if anyone knows when to do the 'update statistics' ? > Or, if there is any information (some ratios, for example) indicates >that the engine needs 'update statistics'?? > >leo > > When users complain the system is getting slow ? Seriously most sites I know of run it overnight as well as bcheck's/tbcheck's to make sure the database is consistent. On a very large site you make have to break it up and update statistics for a few tables day of the week. -- David Williams