How to go about picking a good PARTITION key for a big table, and what are some of the “gotchas” of a badly chosen PARTITION key. It might seem to be simple, but you need to give a good explanation covering all the basics.