Home -> Mailing Lists -> Oracle-L -> Statistics collect ESTIMATE x COMPUTE

Statistics collect ESTIMATE x COMPUTE

From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Tue, 27 May 2014 22:16:03 -0300
Message-ID: <CAJdDhaO6L7c2RGV5xcG6TuJqPYi21SpFxXBA09EKY64HH6pbBg_at_mail.gmail.com> 





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


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


Received on Wed May 28 2014 - 03:16:03 CEST












Original text of this message