Simple report but a lot of data and crashing
Summary
report to show contacts who have emailed over the past yearContent
What is better - both options crash.
OPTION 1
Incidents table is root
Inner joining with Contacts to Incidents (800,000 incidents
Outer joining Org table to Contacts (1.3 million contacts)
OPTION 2
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.
Version
20A
Tagged:
1