I have software package that has Rule Based Optimization and in the init.ora file in Oracle-8i the optimization flag is set RULE. I can not upgrade to CBO because of software package.
If I do ANALYZE ON TABLES OR SCHEMAS does it benefit anything in performance? Some say it will harm the existing RBO queries. Is this correct? Do I need to clear all the analyze optimization data from the tables what I did as test before posing this question?