Re: Computing statistics and query plans

Server Concepts 7.3 Chapter 9 Memory Structures and Processes p9-24

"... When the ANALYZE command is used to update or delete the statistics of a table, cluster, or index, all shared SQL areas that contain statements that reference the analyzed object are flushed from the shared pool. The next time a flushed statement is executed, the statement is parsed in a new shared SQL area to reflect the new statistics for the object. ..."

Regards

Robert

On Wed, 26 Jan 2000 07:13:29 -0000, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>My biggest problem with the manuals is trying to
>find something that I know exists.
>
>You might look in:
> SQL reference under Anaylze
> Oracle Concepts under Shared Pool
> Oracle Tuning under Tuning Memory and Optimization
>
>but I can't give you an guaranteed location.
>Sorry
>
>--
>
>Jonathan Lewis
>Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
>wtgreen_at_my-deja.com wrote in message <86l7m6$301$1_at_nnrp1.deja.com>...
>>Thanks, this was exactly what I was looking for. Excuse my use of the
>>term "query plan" - my Sybase roots are showing. : ) Do you know by
>>the way in the documentation where this is stated, however? While I
>>have suspected as much, I'd like to know where to point others here
>>that question the accuracy of this statement, which up until this
>>point, has really just been an assumption of mine.
Received on Thu Feb 10 2000 - 00:00:00 CST