Physical Design: Indexing- Stuck! need help
 

Consider the relation R(A,B,C,D), consisting of 100,000 tuples. Each page contains 10 tuple entries. R is saved as a heap with dense secondary indexes on B. Data is distributed randomly. The attribute B lies densely in [1, 100,000] i.e., each value in [0, 100,000] occurs in B. Consider these three...