How does Oracle decide how to retrieve the necessary data whenever a valid SQL statement is processed?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Select the steps involved in executing statements in Oracle
- Which of the following is/are applicable for SQL tuning advisor in automatic performance tuning of oracle d...
- Which are the two ways of retrieving the execution plan for an SQL statement?
- The Oracle optimizer should be controlled in choosing the type of joins
- You use comments in a SQL statement to pass hints to the Oracle optimizer.
- You use comments in a SQL statement to pass hints to the Oracle optimizer.
- Which of the following is/are true about instance tuning in oracle database?
- Which of the following can be used as first steps to tune SQL Statements