Activity › Forums › Salesforce® Discussions › What is skinny table?

  • Nikita

    Member
    August 13, 2019 at 12:11 pm

    Hi Saddam,

    Salesforce can create skinny tables to contain frequently used fields and to avoid joins. This can improve the performance of certain read-only operations. Skinny tables are kept in sync with their source tables when the source tables are modified.

    Skinny tables can be created on custom objects, and on Account, Contact, Opportunity, Lead, and Case objects. They can enhance performance for reports, list views.

    Skinny tables can contain the following types of fields.

    Checkbox
    Date
    Date and time
    Email
    Number
    Percent
    Phone
    Picklist (multi-select)
    Text
    Text area
    Text area (long)
    URL

  • Laveena

    Member
    August 19, 2019 at 12:38 pm

    Hi Saddam,

    A skinny table is a custom table in the Force.com platform that contains a subset of fields from a standard or custom base Salesforce object. Force.com can have multiple skinny tables if needed, and maintains them and keeps them completely transparent to you.

    Skinny Table considerations:

    Skinny tables don’t include soft-deleted rows (i.e., records in the Recycle Bin with isDeleted = true)
    Automatically synchronizes the rows between the base object and the skinny table.
    To ensure optimal performance, they contain only the minimum set of fields required to fulfill specific business use cases.
    Adding a new field in skinny table, contact Salesforce support to re-create table again.
    Skinny tables don’t get copied over to sandbox organizations
    Skinny tables are custom tables in the underlying Force.com database.
    Changing any field type in main table will invalid skinny table, contact salesforce support to re-create table again.

    Thanks
     

Log In to reply.

Reply

Subscribe

Popular Salesforce Blogs

Popular Salesforce Videos

Report

Harassment or bullying behavior
Harassment or bullying behavior
Contains mature or sensitive content
Contains misleading or false information
Mobile App Reported Contents
Contains abusive or derogatory content
Contains spam, fake content or potential malware

Block Member?

Please confirm you want to block this member.

You will no longer be able to:

  • See blocked member's posts
  • Mention this member in posts
  • Invite this member to groups
  • Message this member
  • Add this member as a connection

Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.

Report

You have already reported this .