Keith,
To my
knowledge, RBO has not changed. That includes NOT dealing w/ IOT.
So, I think if you execute a query that references an IOT, you'll implicitly
invoke the CBO. That would explain why the plan is changing. So, did
you change a table from heap to IOT when you moved to 9i? If so, that's
what's invoking CBO.
-Mark
PS fatcity is going away, use freelists.org!
Mark J.
Bobak
|
Title: Message