System R Decision Making and Left-Deep Join Trees Quiz

To reduce the number of alternative plans (correct)

To write intermediate results to temporary files

To ensure all join trees are fully pipelined

To make the search space less restricted

They write all intermediate results to temporary files for later use

They generate fully pipelined plans without writing intermediate results to files (correct)

They generate plans with limited joins

They avoid generating fully pipelined plans

By generating all possible join trees

By increasing the number of alternative plans

By ensuring all plans are written to temporary files

By restricting the number of alternative plans (correct)

<p>Ability to generate fully pipelined plans</p> Signup and view all the answers

<p>Due to cases like SM join</p> Signup and view all the answers