Re: Statistics during a complex load

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Sun, 20 Feb 2011 10:27:49 -0800 (PST)
Message-ID: <fb5dcb79-7a00-40a3-adfa-9b7a84c543da_at_w7g2000pre.googlegroups.com>



Tom:

# Is there some way we can arrange for statistics updates to be triggered automatically as the tables grow? A colleague swears that there's some way to tell the planner not to trust the statistics, so it will make plans using indexes even when it doesn't know that's a good idea; can anyone shed any light on that?

That's a deep and complicated subject. One option is to delete the table statistics with cascade set to true ( the default ) so that index stats also are ditched ... then use dynamic sampling.

Lots of variations there between letting Oracle make decisions on when to gather statistics or periodically having an algorithm run that makes a decision for you about new statistics. Received on Sun Feb 20 2011 - 12:27:49 CST

Original text of this message