Re: Odd join selectivity
Date: Thu, 6 Mar 2008 18:08:31 -0500
What? He didn't ask you to upgrade to 11g, too?
Hang on to that engineer, I think he's a "keeper". :-)
On Thu, Mar 6, 2008 at 4:28 PM, Charles Schultz <sacrophyte_at_gmail.com> wrote:
> I filed a case with Oracle Support and ended up with a carpet salesman.
> :-( I asked him specifically where this number is coming from and he threw
> metalink note 68992.1 at me. When I told him that 1/NDV does not match any
> of our indexes, he wants me to reset all my statistics back to default, run
> a few 10046 traces, download and install sqlt (the next version of
> traceanalzyer, apparently) and upload all the results. Sound familiar to
-- Cheers, -- Mark Brinsmead Senior DBA, The Pythian Group http://www.pythian.com/blogs -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 06 2008 - 17:08:31 CST