Index Design Guidelines SQL Server 2016 uses indexes to speed up the performance of queries and improve overall database performance. Discover how to design and implement the various index types available in SQL Server 2016.