Sql Server, Query Optimization.
from this organization. Non-clustered indexes — They are separate data structures that store a copy of indexed columns along with pointers to the corresponding rows in the table, making them suitable for a wider range of query optimization scenarios. CREATE [UNIQUE] [CLUSTERED | NONCLUSTERED] INDEX