This page generates simple (in terms of setup and assumptions) 4-way join optimization problems. Given the statistics and tables below, compute the join plan based on Selinger as discussed in class, the result cardinality, as well as the cost in terms of the number of pages that must be read.

Assumptions:

1. The fanout is the same as the number of directory entries
2. Restricted to the join options in the table on the right
3. Joins are on the same attribute
4. Join attr is a key in each table
5. All tuples are the same size
6. Indices are all on this attribute.
7. Joins are not key-foreign key joins
8. There's no cache, so each page must be accessed from disk.

Click to Toggle Answer