What are the features of Oracle optimizer? Does this optimize SQL queries only or is it used for any other purpose also.
Printable View
What are the features of Oracle optimizer? Does this optimize SQL queries only or is it used for any other purpose also.
The oracle optimizer operates on two purposes namely
Cost Based
Rule Based
Setting the oracle optimizer to RULE will make the rule-based optimizer function in such a way by which execution paths, rules are evaluated to find out alternating best path and so on. Setting the oracle optimizer to CHOOSE will make it function the cost-based optimizer by which statistics of objects in database like number of rows, keys and so on are evaluated which helps to know about the cost.