Multiple choice technology databases

The "Leading" hint causes the optimizer to

  1. Use the specified table as the "Last" table in the join

  2. Use the specified table as the "Log" table in the join

  3. Use the specified table as the "Driving" table in the join

  4. Use the query as the "First" query in the set.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The LEADING hint explicitly tells the query optimizer to use the specified table as the driving table in the join order. The driving table is the first table accessed in the join execution plan, which can significantly impact performance.

Keep practicing — related questions