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.