Index
query index
exec sp_helpindex $tableName
clustered index VS non-clustered index
- Only one clustered index per table
- The primary key constraint automatically creates a clustered index on that particular column.
Reference
https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/