Re: Update Statistics

Posted in 1991

John Wheeler — Fri, 3 May 91 13:02:56 PDT — source: Informix-list mailing list archive (1991-1998)

> > Does anyone have a recommendation on how often the update statistics > command should be run? 'update statistics' only updates the system catalogs with the correct number of rows and the 'next-to-highest' and 'next-to-lowest' values so that the optimizer can make an educated guess about the best way to attack a query. Anytime a tables contents change substantially, update statistics *must* be run...in order for the optimizer toknow what it's working with..... ------ John Wheeler - Informix-4GL / SQL * Unix * Broadcast Audio Production Group One Ltd., San Francisco