Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ANALYZE and its impact on queries
Compute will generate more accurate statistics.
However 20 percent will give you a pretty good sample and is an acceptable
alternative if 1. you don't have the temp space for the compute, or 2. you
don't have the time. And I think if you estimate using 40+ percent (or is it 30
percent?), you are getting a compute in the background anyway.
Lisa
Minneapolis,MN,USA
Dan.Hubler_at_midata.com on 06/21/2000 02:10:18 PM
Please respond to ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)
Subject: ANALYZE and its impact on queries
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?
Thanks.
-- Author: INET: Dan.Hubler_at_midata.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Jun 21 2000 - 15:03:27 CDT