You want to track the date of the most recent order placed by each Customer.

Adding a dedicated input table with a single key reference to the Customer table and a field for the MostRecentOrderDate is the most memory-efficient approach. This design avoids adding additional fields to tables that may contain a large numberof records, which would increase memory usage. Instead, the MostRecentOrderDate is stored once per customer in a separate table, minimizing the memory footprint and optimizing query performance since only the relevant data is accessed.

References:

Kinaxis RapidResponse documentation on data modeling and performance optimization.

Best practices in database normalization and data model efficiency provided by Kinaxis.