Re: Wrong optimizer estimate ?
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Michael.Seiwert@xxxxxx
- Date: Mon, 8 Nov 2010 14:51:08 -0800
On Sun, Nov 7, 2010 at 1:53 AM, Michael Seiwert <Michael.Seiwert@xxxxxx>wrote:
> Hi all,
>
> while doing performance tests of some new queries in our application I
> noticed
> one query where the estimated rows differ much from the actual rows in the
> execution plan (Line 7 in the attached execution plan).
For a start, you may want to investigate DBA_TABLES and DBA_INDEXES
to determine when statistics were gathered.
If the data has grown, the actual # of rows could easily be greater than
what is stored in statistics.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts:
