I would suggest getting to know how to read execution plans. Knowing how to read your execution plan can help you to understand index usage and indexes that may or may not be needed to improve your costly queries.

There are also scripts in the ssc scripts section for rating your indexes. You might want to look some of those up and test-drive a few of them.