See as per my knowledge index is based on the table as a base for database objects. The index also holds the index of columns for sorting the table and record the index listed in the database table in the physical storage location of data in the table to achieve the sort of logic. Through the index, I can speed up the data query speed and reduce system response time; can make the connection between the table and the table faster. But, I want to know how to do this mean how to manage SQL Server indexes or what are the points should be considered while building the index.
Bookmarks