SQL Server
-
Clustered and Non clustered indexDB/RDB 2020. 2. 23. 23:00
1. Overview With a clustered index the rows are stored physically on the disk in the same order as the index. Therefore, there can be only one clustered index. With a non clustered index there is a second list that has pointers to the physical rows. You can have many non clustered indices, although each new index will increase the time it takes to write new records. It is generally faster to rea..