InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
The join orders where the right operand of each join is in one of the initial relations are called as ________(a) Right deep join orders(b) Left deep join orders(c) Outer join orders(d) None of the mentionedI had been asked this question in an interview for internship.This intriguing question originated from Choice of Evaluation Plans in chapter Query Processing and Optimization of RDBMS |
|
Answer» CORRECT OPTION is (b) Left deep JOIN orders For explanation I would SAY: The join orders where the right operand of each join is in one of the INITIAL relations are called as left deep join orders. |
|