Re: Statistics collect ESTIMATE x COMPUTE

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_at_googlemail.com>:

> 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_at_sc.com> 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_at_freelists.org [mailto:
>> oracle-l-bounce_at_freelists.org] *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.
>>
>

--
http://www.freelists.org/webpage/oracle-l