Activity Forums Salesforce® Discussions What is Data Skew in SFDC?

  • Laveena

    Member
    August 13, 2019 at 7:22 am

    Hi Saddam,

    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.

  • Deepak

    Member
    August 13, 2019 at 3:43 pm

    Data skew can kill performance of your org
    The majority of Salesforce customers will never suffer performance issues in their orgs. However, there are certain configuration patterns which appear again and again, because they are apparently “good ideas”, but which increase the probability of performance issues arising in our Org. These patterns cause inefficient data distributions at the storage layer, technically known as Data Skew. Data Skew problems and are so hard to anticipate and can have such a dramatic impact on performance that they are known by Salesforce as “the silent killer”.

    Perhaps the most common of these patterns is when a single user owns more than 10,000 records of an object. This type of skew is called ownership data skew. In most cases, the customer will not notice any issue even when having this kind of a situation, but there is one particular situation in which the impact on performance of this kind of Data Skew can be very significant.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos