From an LDV perspective, SFDC mentions Divisions are a way to speed up query response times:

Divisions... make searches, reports, and list views more meaningful to users in very large organizations by segmenting data into logical sections. For example, if your searches are taking a long time or timing out, and your users only need to see a subset of your data, then using Divisions can help improve performance.

I understand the user-experience when using Divisions... simple enough. Useful. But technically, how does this feature work?

Is this a prioritized custom index that the platform maintains?

EDIT: OP's links are dead, I think this is what the links were: https://help.salesforce.com/s/articleView?id=000329515&type=1

  • 3
    Salesforce being based on Oracle, I suspect this is using partitions.
    – Phil W
    Sep 21, 2019 at 19:22
  • but custom indexes are expensive in terms of insert/update. They actually have a technical downside. Do "Divisions" have a downside or a tradeoff? I want to know... but to answer this I need to know what they are... their quiddity. All I know is what they are probably NOT... I do not think they have anything to do with Share Tables or Group Maintenance Tables, for example. I think @PhilW might be right. But then my next question is "ok, so what is the downside to using Partitions"? Is there a con or tradeoff?
    – krigi
    Sep 21, 2019 at 22:04
  • 1
    My question would be: will your users notice any technical (performance) downside? Remember, you are running in the cloud on virtualized servers using a proprietary, multi-tenant platform. The UX has arbitrary latency anyway (entirely based on what your neighbours are doing) and you don't otherwise pay for CPU usage as such (just limited to a certain amount per transaction).
    – Phil W
    Sep 22, 2019 at 9:27
  • 1
    Old question but since this is a Q&A site, regardless of what OP was looking for it would be helpful to understand what divisions do on the back-end as a community
    – brezotom
    Aug 3, 2021 at 15:18
  • 1
    @krigi i like the way you are thinking about this... did you ever get an answer to this q? also as an aside, you inspired this question - salesforce.stackexchange.com/questions/386267/… Sep 26, 2022 at 18:01


You must log in to answer this question.

Browse other questions tagged .