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 Table considerations:
- Skinny tables don’t include soft-deleted rows (i.e., records in the Recycle Bin with isDeleted = true)
- Automatically synchronizes the rows between the base object and the skinny table.
- To ensure optimal performance, they contain only the minimum set of fields required to fulfill specific business use cases.
- Adding a new field in skinny table, contact Salesforce support to re-create table again.
- Skinny tables don’t get copied over to sandbox organizations
- Skinny tables are custom tables in the underlying Force.com database.
- Changing any field type in main table will invalid skinny table, contact salesforce support to re-create table again.
Comments