This preview shows page 1. Sign up to view the full content.
Unformatted text preview: o Cost of indexed nested loop join of the output of selection and PROJECT = 1000 * (2+1) = 3,000 o Total cost = 1002 + 3000 = 4002 2. a) at most 1000 tuples. b) approximately 10,227 tuples ENGINNER Salary>55000 (use index on Salary) PROJECT ID=ICEngID (use index on ICEngID) pipeline...
View Full Document
- Winter '11