RE: ANALYZE and its impact on queries

It just provide more accurate statistics for the optimizer to take decision. It looks like in ur case the data is highly scattered on vlaues. U can probably create histograms to provide more accurate information to the optimizer instead of analyze with compute. Analyze with compute takes hell lot of time for large tables specially in data warehouse

Hope this help.

-----Original Message-----
From: Dan.Hubler_at_midata.com [mailto:Dan.Hubler_at_midata.com] Sent: Wednesday, June 21, 2000 3:10 PM
To: Multiple recipients of list ORACLE-L 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).