Re: Statistics contradiction can cause wrong cardinality estimation

From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 22 Jul 2008 11:54:51 -0700
Message-ID: <a9c093440807221154p2796c9f4wa141c12c72c03583@mail.gmail.com>


A couple comments:

I would recommend to always use YYYY as RRRR/RR was introduced as a Y2K workaround.
This should yield a number value for Pstart/Pstop vs. a KEY/KEY plan.

Based on your note that recollecting stats resolved the issue, what command was used to gather stats the produced the bad plans? What command was used to produce the good plans? What differences in the stats did you observe?

--

Regards,
Greg Rahn
http://structureddata.org
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jul 22 2008 - 13:54:51 CDT

Original text of this message