Re: Q: Estimated Cost from SET EXPLAIN?

Posted in 1995

Herbert Birkenbach — Wed, 26 Jul 1995 12:09:26 GMT — source: Informix-list mailing list archive (1991-1998)

Hey Folks, there is a Problem with OnLine 5.X and UPDATE STATISTICS. On tables, where frequently deletes are executed on, npused is not computed correct. The effect shows after UPDATE STATISTICS. The consequences are: - The Optimizer blows - If the INSERTS and DELETES are executed concurrently, you can encounter errors -243 and -244 The solution is: - Recalculating and updating npused manually after UPDATE STATISTICS First estimate: nrows * rowsize * <factor> Good luck +-------- Herbert Birkenbach--------------------------------------------+ | CSS Fulda GmbH | | birke@.css.de +49 661 93920 Justus-Liebig-Str. 2-4 | | Germany 36093 Kuenzell | +-----------------------------------------------------------------------+