O'Reilly logo
  • DANIEL ZHANG thinks this is interesting:

in a term-partitioned index, that would require a distributed transaction across all partitions affected by a write, which is not supported in all databases

From

Cover of Designing Data-Intensive Applications, 1st Edition

Note

And transaction means cost.