but the start time doesnt indicates that the object is the most recent, it just indicates when the object was added to your table. If your queries involve the start_time I can understand why u set it as a partition column, otherwise is isnt useful. In most of my queries I query by one of 2 options :
1.Where end_time is null
2.Where start_date>DATE and end_date <DATE
I think that doing the following will be the best option :
partition by list (end_time) - (1 for all non null (non infinity) and 1 default for all those who has end_time that isnt null)
on each partition I'll create range partition on the end_date so that I can search for revisions faster.
What do you think ?
