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.
- Slower
- Faster
- Comparatively Slower
- None
Answer: B) Faster
Explanation:
Nested-loop joins optimized with indexed nested loops are faster than traditional loop joins.