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.
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.