Partitioning on an encrypted column should be avoided because of a security issue: the partition into which each row is assigned will reveal how the plaintext value of the encrypted column tested against the partitioning rules. That is, some information can be inferred from the partition the row is in.

Although such partitioning is allowed, we recommend avoiding it unless the security concerns are well understood and accepted and the application design requires it.

Encrypted columns can be included in partitioned tables.