You have been asked to create a report that displays the following information:
- Assigned case worker (.pxAssignedOperatorID)
- Requestor (.pxCreateOperator)
- Request date (.pxCreateDateTime)
- Due date (.DueDate)
- Assigned vendor (.VendorName)
The report contains a filer to only return purchase requests with a status (.pyStatusWork) of open.
Which property can you optimize to improve report performance?
Optimizing the .pyStatusWork property can significantly improve report performance because it is used as a filter to return only purchase requests with a status of open. By optimizing this frequently queried property, the database can index it, allowing for faster retrieval of the relevant records. Optimizing other fields like .pxAssignedOperatorID, .DueDate, or .pxCreateDateTime, while useful for sorting or displaying data, will not have as significant an impact on performance as optimizing the filter property.
answer should be B