Types of indexes (Types of Indices) see Video below!
DBAs are constantly facing challenges with making queries run faster. One of the top tuning procedures is to add an index to the table or tables in order to increase the optimizer's accessibility to the requested data.
*Note - The first three definitions are excerpts from lyrics in my index song. The remaining definitions come from the referenced link below. Again, my intentions are to inspire listeners to learn through my songs. For example - The different types of indexes in SQL Server 2016 are now ingrained in my memory!
ONLINE REFERENCE: https://msdn.microsoft.com/en-us/library/ms175049.aspx