A developer manages an application that writes customer orders to an Amazon DynamoDB table.

A global secondary index is the correct way to support a new DynamoDB access pattern that uses a different partition key from the base table. The existing table is keyed by customerId and orderId, but the new Lambda function must query by order_date and orderId. An LSI cannot solve this because an LSI must use the same partition key as the base table and only allows an alternate sort key. A table scan is operationally inefficient and becomes expensive and slow as the table grows. DynamoDB Streams are for change data capture and event-driven processing, not for querying historical records by a new key pattern. A GSI with order_date as the partition key and orderId as the sort key directly supports efficient Query operations.

===============