data-analyst video for a single long-running query joins a huge fact with a skewed dimension (one country dominates). AQE is ON, yet shuffle partitions still
A single long-running query joins a huge fact with a skewed dimension (one country dominates). AQE is ON, yet shuffle partitions still blow out to 40 000; runtime is 40 minutes. Quickest fix without rewriting the query?