Multiple choice technology databases

What is TRUE about driving table?

  1. It's advisable to choose the driving table with maximum number of records

  2. Number of records is NOT the criteria while selecting driving table

  3. It's advisable to choose the driving table with less number of records

  4. Driving table is always the last table accessed by the Optimizer
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In join operations, the driving table (accessed first by the optimizer) should typically be the smaller table or the one with the most selective filter condition. This minimizes intermediate result sets and improves overall join performance.

Keep practicing — related questions