Questions tagged [data-skew]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
154 views

Will lookup skew be an issue on low-activity lookup on a high-activity table?

I'm wondering if it is safe to add a lookup that will have >50,000 children under a single parent. The child table has lots of inserts and lots of updates happening in parallel. However, the lookup ...
1
vote
1answer
279 views

Ownership skew in very large data volumes

I have a question with regards to ownership skew in an implementation with several millions of records. Having read all the recommendations and related posts in this forum and in other sites, I am ...
7
votes
2answers
1k views

The cause of UNABLE_TO_LOCK_ROW error?

My scenario is as followed, I have a single Parent account with about 600 child accounts. Every child account has a single Opportunity with 2 or more lines. I have a monthly batch job to create ...
0
votes
1answer
444 views

Parent - Child Records and Ownership/data Skew

I am aware of the concept of ownership skew (https://developer.salesforce.com/blogs/engineering/2012/06/architect-salesforce-record-ownership-skew-for-peak-performance-in-large-data-volume-...
2
votes
2answers
164 views

non-selective query error in sandbox

Is anyone else seeing an increase in non-selective query errors recently? I've been seeing them a lot over the past few weeks, in various instances, in places where they weren't happening before, ...
7
votes
2answers
148 views

Data skew error over 100k records for a managed packaged object

I know Data skew errors for Non-selective queries executed on custom field filters that are not marked as External throw this error, i.e. we cannot run SOQL on an object which has more than 100k ...