Data Skew Salesforce
What is data skew in Salesforce?
Data skew in Salesforce happens when large number of child records (more then 10k) are linked to one parent records.
Type of Data skew
There are 3 types of data skew in salesforce:
- Account data skew
- Ownership skew
- Lookup Skew
Account data skew:
Certain Salesforce objects, like accounts and opportunities, have special data relationships that maintain parent and child record access under private sharing models. Too many child records associated with the same parent object in one of these relationships causes account data skew. Say you have a bunch of unassigned contacts and park them under one account named “Unassigned.” This can create issues with record locking and sharing performance.
Certain Salesforce objects, such as accounts and opportunities, have special data relationships that maintain parent and child record access under private sharing models. If too many child records are associated with same parent object in one of these relationships, this imbalance causes something called “account data skew,” which in turn causes performance problems.
If you are unfamiliar with account data skew, you can read more about it here.
Similarly, when a large number of records with the same object type are owned by a single user, this imbalance causes something called “ownership skew.” Ownership skew also causes performance problems, which can surface when you’re managing your role hierarchy and sharing rules.
If you are unfamiliar with ownership skew, you can read more about it here.
Lookup skew happens when a very large number of records are associated to a single record in the lookup object. Because you can place lookup fields on any object in Salesforce, lookup skew can create problems for any object within your organization.
For more details about data skew refer to official salesforce link.