A nonclustered index has a separate structure from the table. Its entries contain the index key values and a row locator pointing to the base-table row. On a heap, that locator is a row identifier; on a clustered table, it is the clustered index key.
Medium
sql
database