Re: CBO Bug - Tables with 0 rows
- From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
- To: David.Best@xxxxxxxxxx
- Date: Thu, 29 Nov 2007 14:14:12 -0600
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@xxxxxxxxxx> 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.'
- References:
- CBO Bug - Tables with 0 rows
- From: Best, David
Other related posts:
- » CBO Bug - Tables with 0 rows
- » Re: CBO Bug - Tables with 0 rows
- » RE: CBO Bug - Tables with 0 rows
- » Re: CBO Bug - Tables with 0 rows
- » RE: CBO Bug - Tables with 0 rows
- » RE: CBO Bug - Tables with 0 rows
- » RE: CBO Bug - Tables with 0 rows
- » RE: CBO Bug - Tables with 0 rows
- CBO Bug - Tables with 0 rows
- From: Best, David