Oracle Cost Based Optimizer & Effect of Optimizer_index_cost_adj Parameter
Whenever a valid SQL statement is processed Oracle has to decide how to retrieve the necessary data. This decision can be made using one of two methods:� Rule Based Optimizer (RBO) – This method is used if the server has no internal statistics relating to the objects referenced by the statement. This method is no … Read more