On 11/11/20 4:31 PM, Atul Kumar wrote:
Hi, I want to about best practices of partitioning in prod environments and how to identify partitioning columns.
It depends on what you want to do. If your purpose is to simplify the deletion of old records, then partition by an unchanging date field. If your purpose is to increase locality of data (because many of your queries are an equality on a specific "group id"), then partition by that "group id" field.
-- Angular momentum makes the world go 'round.
