5. Using Data at Rest Encryption : Optimizedb Considerations for Data at Rest Encryption
 
Share this page                  
Optimizedb Considerations for Data at Rest Encryption
When the optimizedb utility is used to create statistics for encrypted columns, the histogram cells will contain unencrypted (plain text) data. The histogram cells are statistical extracts, and cannot be linked back to any particular row in the table (except when there is only a single table row). Nevertheless, depending on the nature of the data and your business, this may be considered a security breach.
By default, the optimizedb program skips encrypted columns, but they can be included by specifying the -ze flag. Alternatively, the -r (relation) and -a (attribute) flags can be used to specify exactly which tables and columns to include.
You can verify which columns have had statistics generated for them with the statdump command.