Partitioning by a high-cardinality artificial key (TRANS_ID). This distributes data evenly but provides no query benefit — nobody queries by "TRANS_ID between 100000 and 200000." - Partitioning by a low-cardinality column (STATUS). You end up with a few massive partitions and many empty ones. - Part