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

Home -> Community -> Mailing Lists -> Oracle-L -> ANALYZE and its impact on queries

ANALYZE and its impact on queries

From: <Dan.Hubler_at_midata.com>
Date: Wed, 21 Jun 2000 12:57:45 -0500
Message-Id: <10535.110041@fatcity.com> 





Have a data warehouse.



Did an ANALYZE on all the tables using the ESTIMATE STATISTICS SAMPLE 10
PERCENT clause.



A query that runs for a long time given that scenario.



Did another ANALYZE on the tables using COMPUTE STATISTICS.



Explain plan show that join operation(s) change from nested loop  to  hash.




Does ANALYZE with COMPUTE populate any more statistics than ANALYZE with
ESTIMATE  does?


Or just provide more accuracy?
Received on Wed Jun 21 2000 - 12:57:45 CDT












Original text of this message













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