Re: CBO Bug - Tables with 0 rows

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 29 Nov 2007 14:14:12 -0600
Message-ID: <ad3aa4c90711291214r33de922fu92aad9568fe0ae12@mail.gmail.com>

Sounds like something we do w/ SIebel, I dont think its an Oracle bug, its a problem with settings Siebel wants used.

On Nov 29, 2007 2:00 PM, Best, David <David.Best_at_cognos.com> wrote:

>
>
> 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
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Nov 29 2007 - 14:14:12 CST