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 ?