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?
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here