Home » MCQs » DBMS MCQs » DBMS Nested-Loop Join Algorithm MCQs

Nested-loop joins optimized with indexed nested loops are ____ than traditional loop joins

20. Nested-loop joins optimized with indexed nested loops are ____ than traditional loop joins.

1. Slower
2. Faster
3. Comparatively Slower
4. None

Answer: B) Faster

Explanation:

Nested-loop joins optimized with indexed nested loops are faster than traditional loop joins.