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 -> Re: Do I have to analyze SYS and SYSTEM objects?

Re: Do I have to analyze SYS and SYSTEM objects?

From: Patrick Dean Rusk <ruskies_at_mediaone.net>
Date: Wed, 31 Jan 2001 01:47:36 GMT
Message-ID: <Y8Kd6.29815$t3.5498296@typhoon.ne.mediaone.net> 






I know that I read in either Oracle documentation or the O'Reilly
performance book that the queries for SYS objects are tuned for the
rule-based optimizer. So, analyzing the SYS tables is, indeed, recommended
against.



Pat
Received on Tue Jan 30 2001 - 19:47:36 CST












Original text of this message













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