Re: Update Statistics Guidelines

Posted in 2007

Superboer — 15 Mar 2007 11:13:56 -0700 — source: Usenet: comp.databases.informix

> Sometimes not even this has been enough as we have one frequently-used > transient table that can contain anything from 0 to 50000 rows. If > update statistics was last ran when there were 0 rows the engine favours> sequential scans which are very inefficient when the table gets large. > We ended up with this coding optimiser hints into our code to force use > of the indices. This somewhat obviates the need for "update statistics". where is OPTCOMPIND set to?????? if itś 2 then you can end up having the above problem. if it is 0 you --should-- not get this problem. Superboer.