InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 09:32:12 GMT20http://www.sqlservercentral.com/Forums/Topic1409753-392-1.aspx[i]IF and only if[/i] ABC.COLUMN2 is a (very) large column, and ABC.COLUMN1 is used by itself a lot, it might be worthwhile to keep both indexes.You should also review sys.dm_db_index_usage_stats to see how often, and in what ways, each index is currently being used.Thu, 24 Jan 2013 09:33:53 GMTScottPletcherhttp://www.sqlservercentral.com/Forums/Topic1409753-392-1.aspxUnless your users have specific interest in using that index as an hint, thereby forcing the optimizer to think that you're smart enough to trick it. Apart from this I don't find any use of that index, as it's just a duplicate index lying there, and occupying unnecessary space. I would usually let the optimizer do that work for me rather than forcing it to choose something else which might no be the best alternative, and could impact performance.Regards,FaisalTue, 22 Jan 2013 05:11:21 GMTfaisalfarouqihttp://www.sqlservercentral.com/Forums/Topic1409753-392-1.aspxSince indexes are Left Based, the second index is a duplicate.The only reason to not remove it is if somebody is using an index hint with the name of this second index.Removing it [u]should[/u] have no negative impact. But really, you should test in your dev/qa environments first.Mon, 21 Jan 2013 17:14:53 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1409753-392-1.aspxHi guys, I have question for you guys,I have one table ABC (For Example) and Table ABC has few IndexesFirst Index on Table ABCCOLUMN_NAME = ABC.COLUMN1COLUMN_NAME = ABC.COLUMN2Second IndexColumn_Name = ABC.COlumn1My question is Would it be same. I can understand if i have Query with both column COlumn1 & Column2then First Index is good. What you think should i delete Second Index or Keep, if i keep secondindex its not gonna slow down the performance?Please guide me. Thank YouMon, 21 Jan 2013 17:12:54 GMTrocky_498