Factors Affecting the Index Design Process - Relational Database Index Design and the Optimizers - page 102

SELECT C, E, F
FROM TABLE
WHERE B = :B
AND
C > :C
AND
D = 1
ORDER BY C

P,C

A C

TABLE

10,000,000 rows

Figure 6.5 Exercises 6.1 and 6.2.

6.2. Assume that one second would be an acceptable elapsed time and that we are reluctant
to add a new index. What would you need to know to predict the improvement
provided by alternative 1?