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
--
http://www.freelists.org/webpage/oracle-l


Other related posts: