Re: Optimizer statistics poll
Date: Tue, 10 Apr 2012 09:35:21 -0700 (PDT)
Message-ID: <1334075721.19936.YahooMailNeo_at_web160903.mail.bf1.yahoo.com>
Agreed; I responded based upon our use of 10.2.0.x for some clients where using the default values for statistics gathering can throw a 'spanner into the works' (so to speak). Partitioned tables are especially prone to basically useless statistics -- frequency histograms on single-valued non-null columns and histogram counts based on the sample size rather than extrapolatng the results to reflect the entire table come to mind.
It would be a nice to have these results broken down by version. David Fitzjarrell
From: "Powell, Mark" <mark.powell2_at_hp.com> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Tuesday, April 10, 2012 10:18 AM
Subject: RE: Optimizer statistics poll
I think the poll is valid providing you understand the limitation of the result due to the lack of version specificity. The results would be much more useful if broken down by version.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kellyn Pot'vin
Sent: Monday, April 09, 2012 7:25 PM
To: greg_at_structureddata.org; oracle-l_at_freelists.org
Subject: Re: Optimizer statistics poll
Hey Greg,
As was *whined* about earlier...:) -Aren't the results biased and considerably incorrect due to the lack of Oracle version referenced in the poll?
Kellyn Pot'Vin
Senior Technical Consultant
Enkitec
DBAKevlar.com
From: Greg Rahn <greg_at_structureddata.org> To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Monday, April 9, 2012 4:58 PM
Subject: Optimizer statistics poll
Please consider participating in this poll. http://timurakhmadeev.wordpress.com/2012/04/09/method_opt/
--
Regards,
Greg Rahn | blog <http://bit.ly/u9N0i8> | twitter <http://bit.ly/v733dJ> | linkedin <http://linkd.in/gregrahn>
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 10 2012 - 11:35:21 CDT