An index on a combination of columns is just as flexible as multiple indexes on the individual columns,so either choice would be appropriate.

Question

Quizplus · Accepted Answer

An index on a combination of columns is not as flexible as multiple indexes on individual columns because it can only be effectively used by queries that utilize the leading column(s) in the index. Queries that do not involve the leading column cannot use the composite index efficiently, whereas multiple single-column indexes can be used independently by different queries.

An Index on a Combination of Columns Is Just as Flexible