Btree index question

[tboyer]

Good morning, I'm looking at using more multiple-column indexes to improve query performance.

If I have an index on fruit(name,flavor,color)..

Is there any benefit to an index on just name?

Or will I get good performance from the multiple index for name. I think the answer is yes but I'd like to be sure.

[John]

There isn't any additional benefit to an index on just name. The additional index won't need to be updated, and while the single index will be slightly smaller if some queries use one index, and other queries use the other then you'll lose some of the benefits of caching.