How would you improve performance of the composite worksheet?

You want to create a composite worksheet using two component worksheets. The group by columns in both worksheets are Part.Name, Part.Site, Order.ID, Order.Site, Order.Type, Order.Type.ControlSet, and Line.

How would you improve performance of the composite worksheet?
A . Group the component worksheets by Part.Name, Part.Site and Order.ID. In the composite worksheet group by Order.Type, Order.Type.ControlSet and Line.
B . Ensure that the sort order and sort direction used in both worksheets are the same.
C . Instead of using Part.Name and Part.Site, use Part as a reference in both worksheets.
D . Instead of using Order.ID, Order.Site, Order.Type, and Line replace them with a column that concatenates those values and use it as a group by column.

View Answer

Answer: B

Explanation:

Matching the sort order and direction in both component worksheets before creating a composite worksheet can improve performance. This alignment ensures that the composite worksheet does not have to re-sort the data from each component worksheet, which can be computationally expensive, especially for large datasets.

ReferencesThe recommendation to match sort orders and directions for performance optimization in composite worksheets is in line with best practices for data management in Kinaxis RapidResponse, which can be found in the training and documentation materials.