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:
“Resorts advertised for waitresses, specifying that they must appear in short clothes or no engagement. Below a Gospel Guide column headed, Where our Local Divines Will Hang Out Tomorrow, was an account of spirited gun play at the Bon Ton. In Jeff Winneys California Concert Hall, patrons bucked the tiger under the watchful eye of Kitty Crawhurst, popular lady gambler.”
—Administration in the State of Colo, U.S. public relief program (1935-1943)
“We would not let ourselves be burned at the stake for our opinions: we are not that certain of them. But perhaps we would do so in order to be allowed to possess and to change them.”
—Friedrich Nietzsche (18441900)