An index is a promise to answer one shape of question quickly. Design it from the queries your app actually runs, not from the table definition.