Re: When to use PARTITION BY HASH?

2020-06-07 Thread David Rowley
On Sun, 7 Jun 2020 at 23:41, MichaelDBA wrote: > The article referenced below assumes a worst case scenario for bulk-loading > with hash partitioned tables. It assumes that the values being inserted are > in strict ascending or descending order with no gaps (like a sequence number > incrementi

Re: When to use PARTITION BY HASH?

2020-06-07 Thread MichaelDBA
The article referenced below assumes a worst case scenario for bulk-loading with hash partitioned tables.  It assumes that the values being inserted are in strict ascending or descending order with no gaps (like a sequence number incrementing by 1), thereby ensuring every partition is hit in or