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 > . >