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

1 Answer

0 votes
by

In Salesforce, skinny tables are used to access frequently used fields and to avoid joins. This largely improves performance. Skinny tables are highly effective, so much so that even when the source tables are modified, skinny tables will be in sync with source tables.

Considerations for skinny tables:

Skinny tables can contain a maximum of 100 columns.

Skinny tables cannot contain fields from other objects.

For full sandboxes: Skinny tables are copied to your Full sandbox organizations, as of the Summer ’15 release.

Related questions

0 votes
    The reason I ask is that Stack Overflow has been Slashdotted, and Redditted. First, what kinds of effect ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 1, 2022 in Education by JackTerrance
0 votes
    How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows...
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    What is Fact Table? Explain the different kinds of Facts....
asked Mar 29, 2021 in Technology by JackTerrance
0 votes
    What is Dimensional Table? Explain the different dimensions....
asked Mar 29, 2021 in Technology by JackTerrance
0 votes
    I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow....
asked Mar 28, 2021 in Technology by JackTerrance
0 votes
    In which file database table configuration is stored? (a) .dbm (b) .hbm (c) .ora (d) .sql This ... Autoboxing & Miscellaneous of Java Select the correct answer from above options...
asked Feb 23, 2022 in Education by JackTerrance
0 votes
    explain the concept of splitting and merging cell in a table Select the correct answer from above options...
asked Dec 5, 2021 in Education by JackTerrance
0 votes
    explain the concept of splitting and merging cell in a table Select the correct answer from above options...
asked Nov 26, 2021 in Education by JackTerrance
0 votes
    Explain the Bootstrap basic table?...
asked Apr 4, 2021 in Education by JackTerrance
0 votes
    I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow....
asked Mar 28, 2021 by JackTerrance
0 votes
    I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow....
asked Mar 28, 2021 by JackTerrance
0 votes
    I am working on a voting table design using Postgres 9.5 (but maybe the question itself is applicable ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 26, 2022 in Education by JackTerrance
0 votes
    How to set same number 'priority' with one query for Mercedes. +--------------------- ... questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 20, 2022 in Education by JackTerrance
0 votes
    I would like to ask for performance of SQL. This is my query: Select A.code ,A.name ,(Select B. ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 20, 2022 in Education by JackTerrance
...