Re: Do statistics effect the SQL Runtime engine ?
Date: 13 Feb 2008 08:49:38 GMT
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.comReceived on Wed Feb 13 2008 - 02:49:38 CST