Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Mat. Views and Indexes w/o Analyze

Mat. Views and Indexes w/o Analyze

From: <rpendyck_at_gmail.com>
Date: 27 May 2007 13:01:14 -0700
Message-ID: <1180296074.623341.52900@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?
Received on Sun May 27 2007 - 15:01:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US