As much as possible, Adaptive Server optimizes the copying of encrypted data by copying cipher text instead of decrypting and reencrypting data. This applies to select into commands, bulk copying, and replication.