Widen the index [dbo].[CBI].[inx_hc_rep1]. Add Cash_Point
Widen the index [dbo].[TRANS_HEAD].[IX_trans_head_3]. Add Payment_Method, [trans_type] and episode_key
That should help a bit to start. Post back the revised plan.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability