Formula Query vs Summary Field

Question

Does anyone know if a Summary field (say a total of numbers) or a formula query which gathers the same info, is more resource heavy?

I'm wondering if there is a rule of thumb, like - for a basic summary field on a parent, use summaries. If the summary field will be pulled to a grandparent or great grandparent, use a formula query.

------------------------------
Mike Tamoush
------------------------------

MarkShnierYou · Answer

My own belief is that relationship summary fields are always more efficient even if they have to flow up a few levels. But I don't have a way to prove that. That would be a great question at an EMPOWER session or a formula queries training session.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community