Categories
Sql Server

What are Indexes and it’s types

Index:-An index is a collection of pages associated with a table used to improve the performance.Indexes are used to point to the location of a row on data page instead of  look through all data pages in a table. Planning useful indexes is one of the most important factor of improving query performance. It requires […]