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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 two non-cluster indexes on same column

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.
Go to Top of Page
   

- Advertisement -