Indexes are used to speed-up query process in SQL Server, resulting in high performance. They are similar to textbook indexes. In textbooks, if you need to go to a particular chapter, you go to the index, find the page number of the chapter and go directly to that page. Without indexes, the process of finding your desired chapter would have been very slow.
Read more »![Ben Richardson](https://s33046.pcdn.co/wp-content/uploads/2017/06/Ben.jpg)