Deterministic encryption always generates the same encrypted value for any given plaintext value. Using deterministic encryption ...

Deterministic encryption always generates the same encrypted value for any given plaintext value. Using deterministic encryption allows grouping, filtering by equality, and joining tables based on encrypted values, but could also enable unauthorized users to guess information about encrypted values by examining patterns in the encrypted column.