View PDF External Link Icon

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?