Choosing nonclustered indexes

When you consider adding nonclustered indexes, you must weigh the improvement in retrieval time against the increase in data modification time. In addition, consider:

Because of data modification overhead, add nonclustered indexes only when your testing shows that they are helpful.