Valid Data-Architect Dumps shared by ExamDiscuss.com for Helping Passing Data-Architect Exam! ExamDiscuss.com now offer the newest Data-Architect exam dumps, the ExamDiscuss.com Data-Architect exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com Data-Architect dumps with Test Engine here:
Access Data-Architect Dumps Premium Version
(260 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 9/77
Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters. Which two options can be used to improve report performance?
Recent Comments (The most recent comments are at the top.)
A. Ask support to create a skinny table for Application with the necessary reporting fields.
Skinny tables in Salesforce are used to improve the performance of read-only operations on large data volumes. They contain frequently used fields and are kept in sync with their source tables. By having a skinny table that includes the necessary fields for reporting, UC can experience faster report generation and query execution.
This approach is particularly effective for reports that use filters and need to process large volumes of data.
B. Add custom indexes to the Date fields used for filtering the report.
Custom indexing a field that is frequently used in report filters can significantly improve the performance of those reports. In UC's case, adding custom indexes to the Date fields used for filtering will help optimize the query execution plan and reduce the time taken to retrieve the relevant data.
Salesforce automatically indexes some standard fields like Id, Name, etc., but for custom fields or specific use cases, requesting custom indexing is a beneficial approach....