For Query Plan 1, the Student and Option tables were joined by taking each Student row in turn and scanning the Option table for matching studentNo values. The scan of Option formed an inner loop...


For Query Plan 1, the Student and Option tables were joined by taking each Student row in turn and scanning the Option table for matching studentNo values. The scan of Option formed an inner loop within an outer loop that scanned Student. Would there be any performance advantage if Student were scanned as an inner loop within an outer loop that scanned Option?

Nov 22, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here