One of the easiest ways to increase query performance in SQL Server is to make sure that it can quickly access the requested data, and this is done as efficiently as possible. In SQL Server, using one or more indexes can be exactly the fix you need. In fact, indexes are so important that SQL Server can even warn you when it figures out that there’s an index missing that would benefit a query. This high-level post will explain what indexes are, why they’re so important, and a bit of the both the art and science of various indexing strategies.
