What are skinny tables in Salesforce?

What are skinny tables in Salesforce?

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.

How do I create a table in Salesforce?

To create a table with no existing data in it:

1. Click the Tables tab. If the Tables tab isn’t visible, you can customize your display to show it.
2. Click New Table.
3. Enter a table name and description.
4. Click Create.

How to enable Skinny tables in Salesforce database?

To enable skinny tables, contact Salesforce Customer Support. For each object table, Salesforce maintains other, separate tables at the database level for standard and custom fields. This separation ordinarily necessitates a join when a query contains both kinds of fields.

Can a skinny table be used on Force.com?

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)

How are skinny tables kept in sync with Source Tables?

Skinny tables are kept in sync with their source tables when the source tables are modified. If you want to use skinny tables, contact Salesforce Customer Support. When enabled, skinny tables are created and used automatically where appropriate. You can’t create, access, or modify skinny tables yourself.

What kind of data is in Skinny table?

Skinny Tables can contain the field types Checkbox, Date, Date and Time, Email, Number, percent, Phone, Pick list (Multi Select), Text, Text area (long), Text area and URL. It can also contain encrypted data. The Force.com automatically synchronizes the rows between skinny table and the base object, so the data always be in sync.