How can I optimize my reports loading time

[Marcia2]

I have a report reporting on the Incident table, to do the count of how many p1 incidents were resolved this month, last month, and this year, these are different reports. Problem these reports takes very long time to return the results. I have tried to play around with the query but I am not seeing any improvement. So my query also does a dot walk to the Assignment group table to filter by assignment group owner custom field and also dot walk to Assignment group then User to get Division. Those are the only 2 filters that I do the dot walk. Could this be the cause of the slow loading of the report?

So my query would like 

Resolved on 'Last Month' AND Contact type != 'External System' AND Closed code != 'Close Cancelled' AND Priority is 'Critical' AND Assignment Group.SDM.Accountable Division in(...) AND  Assignment.Group Ownership is " ownership"

For this query to load it is taking about 1 and half minute. How can one make the query respond a bit faster?

Thanks

Marcia

[Tsura Andreeva]

Create a new data source arround P1 see if that helps