Oracle optimizer questions and answers

The optimization is determining the most efficient way to execute a SQL statement after considering the factors related to the objects referenced and the conditions specified in the query...
Oracle decides how to retrieve the necessary data whenever a valid SQL statement is processed....