Re: Do statistics effect the SQL Runtime engine ?

From: Mladen Gogala <>
Date: 13 Feb 2008 08:49:38 GMT
Message-ID: <47b2af22$0$1345$>

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
Received on Wed Feb 13 2008 - 02:49:38 CST

Original text of this message