Activity Forums Salesforce® Discussions What is “Data Skew” in Salesforce?

  • Avnish Yadav

    Member
    August 6, 2018 at 5:09 am

    Hello Anurag,

    When you have a very large number of child records associated with the same account in Salesforce, we call that “data skew”.

    Thanks.

  • Prachi

    Member
    August 9, 2018 at 6:14 am

    Hello Anjali,

    “Data skew” is a condition which you will encounter when working for a big client where there are over 10,000 records. When one single user owns that many records we call that condition ‘ownership data skew’.

    When such users perform updates, performance issues will be encountered because of “data skew”. This happens when a single user/ members of a single role own most of the records for a particular object.

    Thanks

  • madhulika shah

    Member
    September 11, 2018 at 1:40 pm

    Hi,

    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 “data skew,” which in turn causes performance problems.

    Thanks.

  • Parul

    Member
    September 23, 2018 at 8:41 am

    For the organizations, which have a very large database CRM designing is a considerable and necessary aspect. They have to maintain hundreds or thousands of records. With database usually, many accounts are associated with the main account and this association of many accounts with a single account is known as data skew. Data skew can impact the performance of your CRM, so it is essential to prevent the data skew to get better performance of CRM by increasing the number of records, which may impact the CRM up to a great extent.

Log In to reply.

Popular Salesforce Blogs