Skip to main content
1 of 3
Madhusudan
  • 233
  • 2
  • 4
  • 10

I would rather suggest following index:

create nonclustered index i_feed2 on dbo.fees (feeID, endDate,programAP,programED,programEX,countryCode,gatewayCode) include (amount,currencyCode,feeType,mandatory) with(data_compression=page,online=on)

Including all filter conditions in where clause as index columns would make the index more selective. Adding fields selected or updated as include column(covering index) will remove RID lookup and would create index seek, which performs better than index scan.

Madhusudan
  • 233
  • 2
  • 4
  • 10