Re: When to update statistics

Paul asked: > > Does anyone have a effective method of knowing when to update statistics > on a database? I know if queries are running really slow, to run it and > usually there is a increase in the performance, but does any one know > where and what to look at to figure out if update statistics needs to the > run? > Paul, I would suggest running update statistics on a table level after inserts or deletes from a table. I like to put it in the code at the end of the program. Then maybe a cron job to do it on the whole database at night. Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # #############################################################################