A data team is working to optimize an existing large, fast-growing table 'orders' with high cardinality columns, which experiences significant data skew and req...