Title: Message
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
Logic
says one thing, experience says another. Question one, are the tables
analyzed? If so, since RBO is deprecated in 9i even setting
OPTIMIZER_MODE=RULE will invoke the CBO.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Keith Moore