index on multiple columns vs multiple indexes on single column

Could someone explain (or point out the relevant documentation about) situations in which you would want to index several columns vs making multiple indexes, one for each column? Also, I understood that the order of columns in a multi-column index was important, but I do not understand why.

Thank you. Received on Fri Sep 09 2005 - 12:02:25 CDT