Makes sense, Date need not be required to be part of index for the problem I posted.

Appreciate your help!

Thank You,

Mandar

Thank You for prompt response Gail Shaw.

Me being considered newbe for the databases.

By adding composite index on productID, Date, VendingMachineID would do the trick or I am missing point...