Column Order
The order in which columns are listed in the index definition is important. It is possible to retrieve a set of row identifiers using only the first indexed column. However, it is not possible or efficient (on most databases) to retrieve the set of row identifiers using only the second or greater indexed column.
For example, imagine a phone book that is organized by city first, then by last name, and then by first name. If you are given the city, you can easily extract the list of all phone numbers for that city. However, in this phone book it would be very tedious to find all the phone numbers for a given last name. You would have to look within each city's section for the entries with that last name. Some databases can do this, others just won’t use the index.
Read more about this topic: Database Index
Famous quotes containing the words column and/or order:
“Sleep sweetly in your humble graves,
Sleep, martyrs of a fallen cause;
Though yet no marble column craves
The pilgrim here to pause.”
—Henry Timrod (1828–1867)
“Russian forests crash down under the axe, billions of trees are dying, the habitations of animals and birds are layed waste, rivers grow shallow and dry up, marvelous landscapes are disappearing forever.... Man is endowed with creativity in order to multiply that which has been given him; he has not created, but destroyed. There are fewer and fewer forests, rivers are drying up, wildlife has become extinct, the climate is ruined, and the earth is becoming ever poorer and uglier.”
—Anton Pavlovich Chekhov (1860–1904)