cs186_sp08_mt2 6 - b. We usually prefer to use pipelining...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
a.4 Two possible join orders for this query are ((LibraryBooks JOIN CheckedOut) JOIN Patrons) and (LibraryBooks JOIN (CheckedOut JOIN Patrons)). If we had excellent estimates of selectivity (but not necessarily of relation sizes), how would we use that information to decide between the two join orders?
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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.

Ask a homework question - tutors are online