Salesforce Decode
Salesforcedecode
Back to questions
Salesforce ArchitectureArchitect (Hardest)scalabilitysharingldv

Architect sharing model simplification program for LDV enterprise orgs

Real World Scenario

Account sharing table 400M rows; sharing recalc nightly; architecture review mandates simplification before LDV crisis.

Expected Answer

• Audit sharing rules criteria owner-based vs manual shares • Retire obsolete criteria rules incremental • Territory Management replace ad hoc manual shares • OWD role hierarchy minimum necessary private vs read • Sharing groups replace user-specific shares • Defer sharing calc async off-peak maintenance window • Target state diagram signed before rule deletion

Follow-Up Questions & Answers

Click to expand — each follow-up includes a direct, interview-ready answer

Direct answer: Audit sharing rules criteria owner-based vs manual shares Also consider: Retire obsolete criteria rules incremental In practice: Territory Management replace ad hoc manual shares Document the decision in an ADR and align with enterprise standards.

Architect Perspective

Sharing simplification is multi-quarter program—incremental retire not big-bang delete all rules.