Consider the following scenario,

You have a large database table called 'Orders' with columns 'OrderId', 'CustomerId', 'ProductId', and 'OrderDate'.

What would be an effective approach to optimize the query performance?

A$.$

Implement full scan on table

B$.$

Use composite index on 'CustomerId' and 'OrderDate'

C$.$

Create an Index on 'CustomerId'

D$.$

Create an Index on 'OrderId'

E$.$

Create an Index on 'OrderDate'