Gangadhara MS (5/7/2014)
PLAN ATTACHED.sp_helpindex 'DML.ExceptionstrackingTable'
IX_DMLIsDeletedFlagganganonclustered located on PRIMARYDMLIsDeletedFlag
IX_gangaddednonclustered located on PRIMARYDMLIsDeletedFlag, OriginalSubscriptionKey
NCIX_ActivationModelnonclustered located on PRIMARYActivationModel, ExceptionType
NCIX_BatchIDnonclustered located on PRIMARYBatchID
NCIX_EntitlementIDnonclustered located on PRIMARYEntitlementID
NCIX_ExceptionsTrackingTable_CalcProductKeyIDnonclustered located on PRIMARYCalcProductKeyID
NCIX_GrpIDChannelIDSeqNononclustered located on PRIMARYGrpID, ChannelID, SeqNo
NCIX_IsDeletedFlagnonclustered located on PRIMARYDMLIsDeletedFlag
NCIX_MachineKeynonclustered located on PRIMARYMachineKey
NCIX_PartnerEntitlementIDnonclustered located on PRIMARYPartnerEntitlementID
NCIX_RUNIDnonclustered located on PRIMARYRunID
PK_ExceptionsTrackingclustered, unique, primary key located on PRIMARYActID, ExceptionType
Do you realize that you have several repeated indexes? IX_DMLIsDeletedFlagganga and NCIX_IsDeletedFlag are useless if you have IX_gangadded.
You didn't include the actual execution plan or table definitions.