Non Clustered Index in SQL Server

A Non Clustered Index in SQL Server stores the index structure separately from the data physically stored in a table. Microsoft allows you to create almost 999 non clustered indexes per table. The SQL Server non clustered index is useful to improve the query performance. For example, say you want to retrieve employees by their … Read more