Salesforce Application Architect Data-Architect Question # 6 Topic 1 Discussion

Ask support to create a skinny table for Application with the necessary reporting fields. This is anoption that can improve report performance by creating a custom table that contains frequently used fields and copies their values from standard or custom objects. Skinny tablesare kept in sync with their source tables and are used in place of them for reports and queries4. Add custom indexes to the Date fields used for filtering the report. This is another option that can improve report performance by creating custom indexes on fields that are often used as filters or join conditions in reports and queries. Custom indexes can speed up data retrieval and reduce query execution time