Hi , I am talking about 11g version. I got that using dbms_stats , it is has more benefits. So, also I got that using comput statistics It will collect FULL (100%) statistics. Thanks for answers. Best Regards Eriovaldo 2014-05-28 17:56 GMT-03:00 David Roberts <big.dave.roberts@xxxxxxxxxxxxxx>: > You haven't mentioned your database version, however assuming you are not > on 8i/9i, then the supported use of the analyse command is limited to > collection of chained row statistics and structure validation. > > As mentioned you should primarily be looking at DBMS_STATS to gather > general statistical information. > > Also note DBMS_STATS benefits from patented estimated stats gathering > algorithms that did not exist when the analyse command was coded! > > D > On 28 May 2014 04:52, "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx> wrote: > >> >> >> If you are collecting statistics for the Optimizer, you should be using >> DBMS_STATS. >> >> See the notes on the ANALYZE command at >> http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_4005.htm#SQLRF01105 >> >> You will notice that the documentation no longer even mentions "compute" >> and "estimate" in the syntax diagram (as it used to in earlier versions) >> >> >> >> >> >> Hemant K Chitale >> >> >> >> >> >> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto: >> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Eriovaldo Andrietta >> *Sent:* Wednesday, May 28, 2014 9:16 AM >> *To:* ORACLE-L >> *Subject:* Statistics collect ESTIMATE x COMPUTE >> >> >> >> Hello, >> >> >> >> I have a doubt: >> >> >> >> When I run ANALYZE TABLE <table name > compute statistics >> >> Will Oracle consider 100% ? >> >> >> >> and >> >> >> >> If I run ANALYZE TABLE <table name> estimate statistics 100 percent; >> >> Is it better than COMPUTE STATISTICS ? >> >> Regards >> >> Eriovaldo >> >> >> >> >> This email and any attachments are confidential and may also be >> privileged. If you are not the intended recipient, please delete all copies >> and notify the sender immediately. You may wish to refer to the >> incorporation details of Standard Chartered PLC, Standard Chartered Bank >> and their subsidiaries at >> https://www.sc.com/en/incorporation-details.html. >> >