Re: Do statistics effect the SQL Runtime engine ?

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 13 Feb 2008 08:49:38 GMT
Message-ID: <47b2af22$0$1345$834e42db@reader.greatnowhere.com>


On Tue, 12 Feb 2008 10:40:04 -0800, srivenu wrote:

> I have a question regarding statistics and SQL runtime engine. The
> oracle CBO uses statistics to generate the PLAN. Once the plan is
> generated, the runtime engine starts working on it. My question is
> whether the runtime engine changes the method of plan execution
> according to the statistics.

Cursors are invalidated if new statistics becomes available. Cursor will be parsed again, if the new statistics becomes available.

--
Mladen Gogala
http://mgogala.freehostia.com
Received on Wed Feb 13 2008 - 02:49:38 CST

Original text of this message