Encryption and Partitioned Tables
Partitioning on an encrypted column could raise a security issue: the partition into which each row is assigned will reveal how the plain text value of the encrypted column tested against the partitioning rules. That is, some information can be inferred from the partition the row is in.
Such partitioning is allowed, but we recommend that you fully understand and accept the security concerns.
Last modified date: 01/26/2023