Question: Consider a relation R (a, b, c, d) that has a clustering index on a and no clustering indexes on each of the other attributes.

 Consider a relation R (a, b, c, d) that has a

Consider a relation R (a, b, c, d) that has a clustering index on a and no clustering indexes on each of the other attributes. the relevant parameters are: B(R) = 1000, T(R) = 5000, V(R, a) = 20, V{R, b) = 1000, V(R, c) = 5000, and V(R, d) = 500. Give the best query plan (index-scan or table-scan followed by a filter step) and the disk-I/O cost for each of the following selections: Sigma_a = 1 AND 6 = 2 AND d = 3(R) Sigma_a =l AND b=2 AND c greaterthanorequalto 3(-R) Sigma_a= 1 AND b

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!