![Why isn't SQL Server using my clustered index and doing a non-clustered index scan? - Stack Overflow Why isn't SQL Server using my clustered index and doing a non-clustered index scan? - Stack Overflow](https://i.stack.imgur.com/c2UTC.png)
Why isn't SQL Server using my clustered index and doing a non-clustered index scan? - Stack Overflow
![SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - A Transactional Behavior - SQL Authority with Pinal Dave SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - A Transactional Behavior - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/duptr1.jpg)
SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - A Transactional Behavior - SQL Authority with Pinal Dave
![Clustered Vs Non Clustered Index. Explaining Key SQL Performance… | by Farhad Malik | FinTechExplained | Medium Clustered Vs Non Clustered Index. Explaining Key SQL Performance… | by Farhad Malik | FinTechExplained | Medium](https://miro.medium.com/v2/resize:fit:718/1*d3_gN3wrhMOSjI6lI30TfA.png)
Clustered Vs Non Clustered Index. Explaining Key SQL Performance… | by Farhad Malik | FinTechExplained | Medium
![SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - SQL Authority with Pinal Dave SQL SERVER - Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/ignoredup1.jpg)