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

Home -> Community -> Mailing Lists -> Oracle-L -> Analayze

Analayze

From: Hamid Alavi <HamidA_at_aimdirect.co.nz>
Date: Thu, 5 Oct 2000 16:56:00 +1300
Message-Id: <10639.118552@fatcity.com> 





Hi,



I have still some few problems affected from ANALYZE result and don't know
if we have 3 tables EX: T1,T2,T3 and run ANALYZE on just T1 then if SQL
statment using these 3 tables which optimizer is going to be used?? CBO or
RBO or both!!!!!!




Hamid Alavi


DDI 3610148



FAX 3610102



111 Franklin RD Freemans Bay Auckland
Received on Wed Oct 04 2000 - 22:56:00 CDT












Original text of this message













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