SQL Server March 17th, 2017 Performance Myths : Clustered vs. Non-Clustered Indexes I show a "redundant" non-clustered index outperforming the clustered index with the same key.