Is there ever a reason to create a non-clustered index on a column that is already the clustered primary key?

0 votes

1 answer

60 views

sql-server index t-sql primary-key nonclustered-index

                          Suppose that I have a table. Its primary key is clustered and consists of exactly one column. Is there ever a reason to _also_ make a non-clustered index on that same column with no other columns in any part of the non-clustered index?
                        

Asked by J. Mini (1237 rep)

Jan 12, 2024, 03:21 PM
Last activity: Jan 12, 2024, 10:22 PM

Is there ever a reason to create a non-clustered index on a column that is already the clustered primary key?

Related Questions