"Geomancer" <pharfromhome@hotmail.com> wrote in message
news:cf90fb89.0311091846.2f25d397@posting.google.c om...
> > but these would have no affect if Siebel has optimizer mode set to RULE,
no?
>
> Yes, but sometimes it is left to the default optimizer_mode=choose.

Yes, I suppose we would not want to trust them -- but if hey're designing
for RULE, think I'd set it the init.ora RULE and not worry about the stats
anymore (hopefully they're the only application in the instance)

>
> I wonder what Siebel will do when 10g comes around with no RBO?

Sounds like they'll upgrade to 8.0 ;-)