CBO Bug - Tables with 0 rows - oracle-l - FreeLists

CBO Bug - Tables with 0 rows

From: "Best, David" <David.Best@xxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 29 Nov 2007 15:00:15 -0500


Hey all,

   Has anyone heard of CBO bugs on tables with 0 rows or a low row count
(<6)?  Appparently sub-optimal plans were generated causing performance
issues.   The solution was to delete statistics on those tables. I was
kind of surprised when I heard this so I searched on Metalink and can't
find anything. 

Thanks
--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Re: CBO Bug - Tables with 0 rows
  - From: Andrew Kerber
- RE: CBO Bug - Tables with 0 rows
  - From: Taylor, Chris David

Other related posts: