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 -> Should one Analyze the Tables created because of intermedia Indexes or not

Should one Analyze the Tables created because of intermedia Indexes or not

From: Ronnie Yours <ronnie_yours_at_yahoo.com>
Date: Fri, 2 Aug 2002 10:58:25 -0400
Message-ID: <aie6rs$clb$2@nntp-m01.news.aol.com> 





Hi,


I have some tables which have intermedia indexes on them. These indexes
create tables such as


DR$HEADLINE_SEARCH$I
DR$HEADLINE_SEARCH$K
DR$HEADLINE_SEARCH$N
DR$HEADLINE_SEARCH$R





I enabled monitoring on them and they show up in the user_tab_modifications
table when data is added/updated or deleted in the master table(the table on
which intermedia indexes are created).



My question is that do these tables need to be analyzed also or not.



Thanks


Ronnie
Received on Fri Aug 02 2002 - 09:58:25 CDT












Original text of this message













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