Indexing a database has always been seen as some form of dark art and it doesn’t need to be that way. Despite being critical to the performance of an application, indexes are generally one of the last things thought about in a database project. A properly indexed database will increase...