How do you choose a data partitioning strategy?

A useful answer structure

Answer from your own work.

1. 01Start with a precise definition and the constraint it solves.
2. 02Explain how data distribution, query pruning, skew, and maintenance changes your implementation or decision.
3. 03Finish with a production example, risk, or verification signal.

Do not memorise a script: use only examples you can explain honestly in follow-up questions.