Universal Containers has 30 million case records. The Case object has 80 fields. Agents are reporting performance Issues and time-outs while running case reports in the Salesforce org.
Which solution should a data architect recommend to improve reporting performance?
To improve performance for agents running case reports with a large volume of records and fields, enabling a skinny table for the Case object is a suitable solution. Skinny tables are specially designed to speed up read-only operations and queries by reducing the number of joins required, thus enhancing reporting performance. Support from Salesforce is needed to enable and configure skinny tables tailored to the specific needs of the organization.
Answer A. Skinny tables can be beneficial for improving reporting performance in Salesforce, especially when dealing with large volumes of data and complex queries. By enabling skinny tables for the Case object, Salesforce creates denormalized copies of the data, which can significantly speed up query execution times and enhance overall performance.
The most accurate answer is A. Contact Salesforce support to enable skinny table for cases. Skinny tables can help improve the performance of reports and list views in Salesforce. They contain frequently used fields and are kept in sync with their source tables. By reducing the number of joins performed during a query, skinny tables can significantly improve the performance of reports and list views
A - Skinny Tables, which are compatible with up to 100 fields, of a certain type
Skinny tables are the fittest to counter reporting performance issues. Moving data off of the platform could have been a solution but it is less efficient than skinny tables for the problem displayed. https://developer.salesforce.com/docs/atlas.en-us.salesforce_large_data_volumes_bp.meta/salesforce_large_data_volumes_bp/ldv_deployments_infrastructure_skinny_tables.htm