1Z0-882 practice - PrepKeys

Q1 Single choice

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?

A
The optimizer processes only the JOINs in the sequence listed in the query.
B
The optimizer will only JOIN the tables by using their PRIMARY KEYS or UNIQUE constraints.
C
The optimizer will only JOIN the tables in sequence from smallest to largest.
D
The optimizer ignores all terms in the WHERE clause until all JOINs have been completed.