What's a good strategy for dealing with indexes (multiple) that would span multiple partitions of a table.
For example: Let's say I have a table that's partitioned by group_id because I want all the records for a group to be in the same partition. Let's say I have a field called "expires_at" which is a date. Let's presume the expiry date can be updated. If I want to do something to every record that is due to be expired the database is going to be touching practically every partition and this seems like it could present a problem. Is there a more efficient way to deal with something like this?
