the estimated row is much below the actual, stats are up to date
CREATE NONCLUSTERED INDEX [IX_CIS_ClientPricingProfile_SelectChargePriceItem_jul_13] ON [dbo].[CIS_ClientPricingProfile]
(
[ClientID] ASC,
[ProcessTypeID] ASC,
[InvoiceDetailTypeId] ASC,
[FeeDescriptionId] ASC,
[TdspId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80)
CREATE NONCLUSTERED INDEX [IXN_CORE_Charges_InvoiceId_Canceled_RolledBack_IsVoidedFeeAmount_jul_13] ON [dbo].[CORE_Charges]
(
[ClientID] ASC,
[ProcessTypeID] ASC,
[InvoiceDetailTypeId] ASC,
[FeeDescriptionId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF, FILLFACTOR = 80)