A nonclustered index does not alter the physical order of the data in the table. Instead, it creates a separate structure to store the index. A table can have multiple nonclustered indexes. The leaf nodes of a nonclustered index contain pointers to the actual data pages, not the data itself.
