Sql Server, Query Optimization.
separate data structure that stores a copy of the indexed columns along with a pointer to the actual data row in the table. Performance — Non-clustered indexes are suitable for optimizing queries that involve columns not covered by the clustered index. They can significantly improve query