Denormalize everything
No joins. Each query → its own table. Duplicate data across tables. Sync via application-level dual writes.
Advertisement
Rethink schema
Design for queries first. Partition key = primary access pattern. Clustering columns = sort + range.
Advertisement
Handle updates carefully
Updates hit all denormalized tables. Batch or async event-based sync (CDC). Consistency window OK for most use cases.