Using a CBO Schema on an RBO Database

Hi

I am installing some software onto an 8i server which is configured to use the RBO. (This is becuase the only piece of software currently using this server has been optimised over the years to use RBO) I want to install some new objects onto this server to be used by my software.
I want to create a new schema that will 'hold' all of my tables, procedures etc on this server. Idealy, I would like to use the CBO (mainly for function-based indexes) but the dba doesn't want me to anlayse any of my objects in my schema for fear it may upset the other schema the originl software belongs to and force that to use the CBO as well.
Am I right in thinking that even if the schema the original software belongs to uses RBO, if I execute an Analyze Schema statement within my schema, only objects within my schema will be analysed and so only my schema will use the CBO. Everything else within the instance will remain unaffected by this and so will continue to use the RBO? Is this true? Has anyone else come across this problem?(The reason I say that is SYS uses RBO but all of the schemas I use on mu dev server are analaysed and so use CBO and I have never run into any problmes doing this.)

Any thoughts would be greatly appreciated.

Many Thanks

Neil Received on Wed Dec 11 2002 - 03:09:59 CST