- Should those queries be written such that CBO is forced to take what the developer thinks is an optimal plan? Interestingly, here the old good NL-loop turns out to be a better plan than hashing, scanning, etc.
- Is the first thing to do with the Oracle instance that to tune OCI? Should high OIC values (the "correct 99.9) be tested immediately? (This is actually what I do - set all OLTP or general purpose instances to favour indexes.)
Regards, Dimitre Radoulov
-- //www.freelists.org/webpage/oracle-l