Re: Mat. Views and Indexes w/o Analyze

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 27 May 2007 21:12:59 +0100
Message-ID: <-Yadnb3paO3Ve8TbnZ2dnUVZ8seinZ2d@bt.com>

<rpendyck_at_gmail.com> wrote in message
news:1180296074.623341.52900_at_p77g2000hsh.googlegroups.com...
> Being a non-dba can someone answer this question? We had 6
> materialized views created in production along with multiple indexes.
> An Analyze was not performed on the new indexes, could this have led
> to memory utilization issues on that server when queries were run
> against these materialized views?
>

Yes

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Received on Sun May 27 2007 - 15:12:59 CDT