• #52033
     Prachi #6
    Forcetalks

    Explain skinny table. What are the considerations for Skinny Table in Salesforce?

    Explain skinny table. What are the considerations for Skinny Table in Salesforce?

    #52191
    Salesforce | S S #101
    Forcetalks
    • For example, if an organization having more than 2 million records for a single object. Which may cause more processing Time. So one way of improving performance is using skinny tables.
    • It stores the frequently used fields and avoids joins.
    • Skinny tables are in sync with their source tables when the source tables are modified.
    #52359
     Divya #11
    Forcetalks

    Hi Prachi,

    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.

    The considerations are as follows:

    1. Skinny tables can contain a maximum of 100 columns.
    2. Skinny tables cannot contain fields from other objects.

    #53663
     William #5
    Forcetalks

    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, and SOQL.

    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

    Considerations

    ·         Skinny tables can contain a maximum of 100 columns.

    ·         Skinny tables can’t contain fields from other objects.

    ·         For Full sandboxes: Skinny tables are copied to your Full sandbox orgs.

    For other types of sandboxes: Skinny tables aren’t copied to your sandbox organizations. To have production skinny tables activated for sandbox types other than Full sandboxes, contact Salesforce Customer Support.

    #54122
    Salesforce | Jade Jade #10
    Forcetalks

    Skinny tables are used for better query results and to avoid governor limits. You need to identify fields to enable as skinny tables and then request to Salesforce to enable them.

    For more details : https://developer.salesforce.com/docs/atlas.en-us.salesforce_large_data_volumes_bp.meta/salesforce_large_data_volumes_bp/ldv_deployments_infrastructure_skinny_tables.htm

     

     

    #54139
    Salesforce | Dharani M Dharani M #42
    Forcetalks

    Skinny Tables. Sales force can create skinny tables to contain frequently used field sand to avoid joins. This can improve the performance of certain read-only operations.

    https://www.upshottechnologies.in/data-science-training-in-bangalore/

    https://www.upshottechnologies.in/big-data-analytics-training-in-bangalore/

    • This reply was modified 1 month, 1 week ago by Salesforce | Dharani M Dharani M.
    • This reply was modified 1 month, 1 week ago by Salesforce | Dharani M Dharani M.
Viewing 6 posts - 1 through 6 (of 6 total)

Please to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

About Us

Forcetalks is a Salesforce collaboration platform for coders & developers, geeks & nerds, consultants & business heads, admins & architects, managers & marketers and of course the business owners. A community where you can learn from, where you can contribute to. For you. For Salesforce. Read More...

Copyright 2019 Forcetalks. All Right Reserved.

Log in with your credentials

or    

Forgot your details?