To improve performance on both equality and nonequality searches, and on joins, create indexes on encrypted columns. See “Performance Considerations” for information on how Adaptive Server makes use of indexes on encrypted columns.
create index reports an error if you create:
A functional index using an expression that references an encrypted column.
An index on a column encrypted with initialization vector or random padding.
