Write Query: Create a Compound Index

To address slow query performance in the orders collection, a compound index should be created on the fields customerId (ascending) and orderDate (descending). This index will optimize queries that filter by customer and sort by the most recent orders, reducing the need for MongoDB to scan and sort large data sets. The existing single-field index on customerId is insufficient, as it does not account for the orderDate sorting requirement.