Message-Id: <10535.110041@fatcity.com> From: Dan.Hubler@midata.com Date: Wed, 21 Jun 2000 12:57:45 -0500 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?