Creating indexes can be one of the most useful performance gains you can add to your database. However, having too many indexes can hurt performance as well as require additional space and maintenance time. The introduction of Dynamic Management Views has made indexing easier; however, there are still many tactics you need to be aware of when applying indexes. This session will cover strategies such as discovering and applying missing indexes, finding and removing overlapping indexes, and identifying rarely used indexes that are expensive to maintain.