Re: Can UPDATE STATISTICS screw up the optimizer?

Posted in 1996

Brenda Reed — Fri, 26 Jul 1996 22:03:35 GMT — source: Informix-list mailing list archive (1991-1998)

Bashar, Chalabi wrote: > If we do the following: > > delete all rows in the table > update statistics> load 100 rows > update statistics> run the procedure > ----- I'm curious, why are you updating the statistics BEFORE you load in the data? I thought statistics were used by the query optimizer when determining the best access method for data, and not used during load or updates. It would seem as if it is an unnecessary step. Brenda Reed