This preview shows page 1. Sign up to view the full content.
Unformatted text preview: b. We usually prefer to use pipelining when evaluating plans. b.1 What are two advantages to fully pipelined plans? b.2 Can we use a sort-merge join in a fully pipelined plan? Why or why not? c. Some optimizers only consider left-deep plans. What are the advantages and disadvantages of doing this?...
View Full Document
This note was uploaded on 08/30/2009 for the course CS 186 taught by Professor Staff during the Spring '08 term at University of California, Berkeley.
- Spring '08