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: CBO when one table has no stats

Re: CBO when one table has no stats

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: 31 Mar 2003 08:49:58 GMT
Message-ID: <Xns934FBF7F79069Tokenthis@210.49.20.254> 





Following up on NetComrade, 31 Mar 2003:



> .......

> We use Oracle 8.1.7.4 on Solaris 2.7 boxes

> remove NSPAM to email




Have a look at the DBMS_STATS package and execution
plan stability.  You need to fix the stats and execution plans
with these, rather than relying on RBO.  With 8.1.7, it's
definitely not needed anymore.


-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam


Received on Mon Mar 31 2003 - 02:49:58 CST












Original text of this message













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