Simple report but a lot of data and crashing
Summaryreport to show contacts who have emailed over the past year
What is better - both options crash.
Incidents table is root
Inner joining with Contacts to Incidents (800,000 incidents
Outer joining Org table to Contacts (1.3 million contacts)
Contacts table is root (1.3 million contacts)
Inner joining with Incidents to Contacts (1.3 million contacts)
Outer joining Org table to Contacts
My assumption is option 1 is better. Hard to explain to leadership the difficulty of not being able to run a years worth or 6 months worth of data.