In future we're going to need to fetch best results for given point in time. Currently it's not efficient as would require reading rows that happened after requested point in time. This is because 'result_date' where clause restriction must happen along with 'key' restriction.
To tackle that problem, need to reorder 'key' and 'result_date' columns. Better to do it early, before we have data there, so we don't need to migrate anything.
In future we're going to need to fetch best results for given point in time. Currently it's not efficient as would require reading rows that happened after requested point in time. This is because 'result_date' where clause restriction must happen along with 'key' restriction.
To tackle that problem, need to reorder 'key' and 'result_date' columns. Better to do it early, before we have data there, so we don't need to migrate anything.