Oracle
1Z0-882 · Question #56
A complex query consists of eight populated tables that are all connected via INNER JOIN operands as shown: You modify the query and replace the SELECT operand with SELECT STRAIGHT JOIN. What is the…
The correct answer is A. The optimizer processes only the JOINs in the sequence listed in the query. See the full explanation below for the reasoning.
Question
A complex query consists of eight populated tables that are all connected via INNER JOIN operands as shown:
You modify the query and replace the SELECT operand with SELECT STRAIGHT JOIN. What is the effect of adding STRAIGHT JOINs to the query?
Options
- AThe optimizer processes only the JOINs in the sequence listed in the query.
- BThe optimizer will only JOIN the tables by using their PRIMARY KEYS or UNIQUE constraints.
- CThe optimizer will only JOIN the tables in sequence from smallest to largest.
- DThe optimizer ignores all terms in the WHERE clause until all JOINs have been completed.
How the community answered
(36 responses)- A72% (26)
- B17% (6)
- C6% (2)
- D6% (2)
Community Discussion
No community discussion yet for this question.