Sergiy (5/24/2016)
jc85 (5/24/2016)
Added start_time as Non-clustered index for table ann_events_Tech_Details.Make it clustered.
Otherwise - drop it, no use of it anyway.
Both tables already have id set as their clustered index so I will drop [start_time].
jc85 (5/24/2016)
Added report_id, report_item, call_flow_name, source as Non-clustered index for table ann_ReportItem[Source] must come first.
You do not need report_item in index pages, it will be good enough just being INCLUDEd.
Did as you said.
You have still DATEADD-DATEDIFF applied to [start_time] in WHERE clause.
If you do not intend to fix that - forget about indexes. They're not gonna help you.
Any suggestion how to write SARGable WHERE clause to replace DATEADD-DATEDIFF?
I have temp removed it and ran another round, SQL exec plan is attached. Thanks !