1.

Explain Skinny Table. What Are The Considerations For Skinny Table?

Answer»

In Salesforce, skinny tables are used to access frequently used fields and to avoid JOINS. This largely improved 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.

In Salesforce, skinny tables are used to access frequently used fields and to avoid joins. This largely improved 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:


Discussion

No Comment Found

Related InterviewSolutions