Glad it helped.

Thanks for the feedback.

I'd recommend a clustered index on ann_ReportItem like this:

CREATE NONCLUSTERED INDEX [ix_RItem] ON [dbo].[ann_ReportItem]

(

[report_id] ASC,

[call_flow_name] ASC,

[source] ASC