Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> CBO Bug - Tables with 0 rows

CBO Bug - Tables with 0 rows

From: Best, David <David.Best_at_cognos.com>
Date: Thu, 29 Nov 2007 15:00:15 -0500
Message-ID: <2B4E386EAEC90947802323BF373DC0EC0CEEEA35@sottemail1.ent.ad.cognos.com> 







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


Received on Thu Nov 29 2007 - 14:00:15 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US