# Case Study Solution (C)

+ Create a composite index with report_dt, reward_type_id, winning_create_time to reduce data access
+ Execution time for SQL statements dropped from 400ms to about 4ms

------------------------------------------------------------

Execution time for SQL dropped from 400ms+ to around 4ms.