I have removed the STATS so the optimizer always uses RULE based. This is due to queries written in this way.
What is the impact of having removed Stats, are they only applicable to the Optimizer or are they needed for other processers?
Printable View
I have removed the STATS so the optimizer always uses RULE based. This is due to queries written in this way.
What is the impact of having removed Stats, are they only applicable to the Optimizer or are they needed for other processers?
Change the OPTIMIZER_MODE to RULE in init.ora file.