Re: Creating indexes on a large table

prg wrote:
> David,
>
> I am using 10.1.0. How can i find out if I am using CBO or not. I
> presume that after 9i, oracle is always using cbo rather than rbo.

You can tell when you explain plan. Generally a true presumption. http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:231814117467

Do you have the partition option?

jg

--
@home.com is bogus.
Why computer engineers should not be surgeons:
http://www.funnytimes.com/cartoons/content/02142001.htm