This content has been marked as final. Show 2 replies
the index will be automatically encrypted, beware that you need to encrypt the column with NO SALT
and that a resulting limitation will become that you can no longer do range scans, this means
the creditcard number can only be found by its index if it is fully known beforehand, see:
note 454980.1 Best Practices For Having Indexes On Encrypted Columns Using TDE Column encryption.
Tablespace encryption does not have this limitation,
Harm ten Napel