-
Explain Skinny table in Salesforce?
Explain Skinny table in Salesforce?
-
2 Replies
-
Salesforce creates skinny tables to contain frequently used fields and to avoid joins, and it keeps the skinny tables in sync with their source tables when the source tables are modified. To enable skinny tables, contact Salesforce.com 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. A skinny table contains both kinds of fields and does not include soft-deleted records.
This table shows an Account view, a corresponding database table, and a skinny table that would speed up Account queries. -
Salesforce can create skinny tables to contain frequently used fields and to avoid joins. Doing so keeps the skinny tables in sync with their source tables when the source tables are modified. ... A skinny table contains both kinds of fields and does not include soft-deleted records.
Log In to reply.
Popular Salesforce Blogs
Lightning Web Component | Salesforce Developer Guide
Lightning Web Component Presently you'll construct Lightning components utilizing two programming models: Lightning Web Components and the first demonstrate, Air Components. Lightning web components are…
Bypassing the “Number of Iterations Exceeded” Error in Salesforce Flows with Platform Events
Elements Limit in Flows Flows in Salesforce are great, but there are some limits that can make working with them very frustrating. One of those…
Salesforce Salaries
The range and scope of opportunities available to a Salesforce professional are among the best in the IT industry and might continue to rise in…
Popular Salesforce Videos
Workplace Command Center | Salesforce
Protect employees and customers with safer workplaces. Use our Workplace Command Center to quickly take action on workplace safety.
Why Salesforce is in Demand? What is Salesforce? Salesforce Developer Jobs And Salary in 2022
In this video, Career Tips With Poonam discusses Salesforce job opportunities, what Salesforce is, Salesforce Developer Jobs and Salary in 2022 and much more.
How To Reset Salesforce Security Token?
Salesforce security token is a case-sensitive unique key that is used to work with Salesforce API. In this video I will show you how to…
