Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunnyh
Starting Member
3 Posts |
 Posted - 2014-02-05 : 08:20:55
|
| Hi,I have two non cluster indexes on same column of a table. Is there any negative impact on table like performance etc. Please suggest. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2014-02-09 : 02:24:55
|
| If the indexes are ONLY on that single column, then yes, there is a negative impact and one should be removed. If they span multiple columns and the indexes are not identical, then you'll have to see if they are both used to determine that.EDIT: have a look here for finding unused indexes. |
 |
|
|
|
|
|
two non-cluster indexes on same column