Toggle Side Panel
Close search

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

  • [adinserter block='9']

  • 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.