Re: Update Statistics Low, Medium & High

Posted in 1996

Nils Myklebust — Thu, 29 Aug 1996 15:09:54 GMT — source: Informix-list mailing list archive (1991-1998)

dehkmis@hk.super.net (Durable MIS) wrote: :In our system, we discover sometimes some tables in index searching is much :faster while we update their statistics low or medium instead of high. This is conceivable in some situations. Update statistics (low, medium or high) only stears the optimiser towards the "right" index to use. It may still not select the best one. If you update low or medium it might use another index that's actually better. Use set explain on and check your sqexplain.out file. :We have an idea that update all tables high statistics with reference to the :server admin. guide. I don't understand this sentence. :Is this correct ? Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company