Optimizing Table Data Structures
Before attempting any schema design, it is critical to understand the nature of the workload. Is data loaded in trickles, large batches or concurrent inserts? Is data ingest speed more important than query performance? Are the queries mostly working with a small subset fo rows related to the entire dataset?