Index Structures and their Usage
A number of query processing techniques that exploit indices
are useful. For instance, the selectivities of multiple
conditions can be exploited through index intersection. Other
useful index operations are union of indexes. These index
operations can be used to significantly reduce and in many
cases eliminate the need to access the base tables.