How to Design Indexes on a Table

Creating more indexes is a bad idea. This post covers how to answer this question in an interview. Just use unique indexes in where clause. So you can avoid creating more indexes.