Activity Forums Salesforce® Discussions What are Skinny Tables in Salesforce?

  • Prachi

    Member
    September 6, 2019 at 4:55 am

    Hi,

    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 tables are most useful with tables containing millions of records. They can be created on custom objects, and on Account, Contact, Opportunity, Lead, and Case objects. In addition, they can enhance performance for reports, list views, and SOSL.

    Salesforce creates skinny tables to contain frequently used fields and to avoid joins, and it keeps the skinny tables in sync with their source tables when the source tables are modified.

    kinny tables can contain the following types of fields.

    1.Checkbox
    2.Date
    3.Date and time
    4.Email
    5.Number
    6.Percent
    7.Phone picklist
    8.Picklist (multi-select)
    9.Text (fewer than 80 characters)
    10.Text area
    11.Text area (long)
    12.URL

    Thanks.

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos