This section presents a study of two queries that must access
a single table, and the indexing choices for these two queries.
The two queries are:
A range query that returns
a large number of rows
A point query that returns only one or two rows
View this book as PDF