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