Exploring the types of indexes
Based on storage type, the index structure is different for each data storage type; these can be disk-based row store indexes, column store indexes, and memory-optimized indexes. Let’s discuss the most important indexes along with some examples.
We will review the types of indexes next.
Clustered indexes
These are an integral part of SQL Server and are used to organize data based on the clustered index value. This type of index allows for the pages of data to be ordered in a specific way, allowing for faster reads and queries. The clustered index then stores the actual data rows in the table, so each table can only have one clustered index. When creating a clustered index, it is important to choose a column or columns that will be used frequently in searches and queries, as this will improve the performance of the database.
Clustered indexes are created using the CLUSTERED keyword in the CREATE statement.
Because the database tables...
