1 | startup (latency) |
2 | interference (communication, locking) |
3 | load balance (execution skew - all the execution occurs in one partition) |
4 | data-partition (data skew - all the data is placed in one partition) |
5 | imbalance of system resources (CPUs and I/O channels) |
6 | CPU-intensive or I/O intensive queries |