I have a question regarding compaction strategy.
Let say I have a workload where data will be inserted once, or upsert (batch of insert for a given partition) but never updated (in terms of column update).
I'm trying to figure out if the use of Size Tiered Compaction Strategy is better than Leveled Compaction Strategy.
Because Size Tiered Compaction does not group data by rows, if I want to fetch an entire partition. (it seems the rows are spread over many SSTable).
Also the partition created will not be updated or added with new column, only during the initial write (like batch), so STC may involve only a single SSTable