Re: Does Ref. Integrity help CBO ?

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 25 Oct 2006 15:11:54 -0700
Message-ID: <1161814314.054094.123440@m7g2000cwm.googlegroups.com>

klabu wrote:
> 10gR2
>
> Does Ref. Integrity help CBO ?
> or maybe my Q should be: Does Statistics take RI into consideration ?
>
> So if say joining n tables....
> Does the fact that these tables have RI amongst them "help" CBO do a
> "better" job
> than if they just have PKs defined ?
>
>
> thanks, hope i'm making sense, I tried ;)

I very much doubt that the CBO does take this into account. Have you though of a test case where RI would help resolve something faster ... you could try it out to see if it makes any difference ...

cheers,
Martin Received on Wed Oct 25 2006 - 17:11:54 CDT