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.

This table shows an Account view, a corresponding database table, and a skinny table that can speed up Account queries.

By having narrower rows and less data to scan than the base Salesforce object, skinny tables allow force.com to return more rows per database fetch, increasing throughout when reading from a large object.

Force.com can have multiple skinny tables if needed, and maintains them and keeps them completely transparent to you.

Skinny Table considerations:

1. Skinny tables don’t include soft-deleted rows (i.e., records in the Recycle Bin with isDeleted = true)
2. Automatically synchronizes the rows between the base object and the skinny table.
3. Skinny tables don’t get copied over to sandbox organizations
4. Skinny tables are custom tables in the underlying Force.com database.

For each object table that’s visible to you, Salesforce maintains other, separate tables at the database level for standard and custom fields.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s