All Forums Database
JustMe 76 posts Joined 03/07
06 Nov 2014
Encryption in the index

Can a column that will be encrypted be used as part of an index? 

Raja_KT 1246 posts Joined 07/09
06 Nov 2014

I am not sure. Will it hash?????. But I don't think it is advisable , since when use in  where clause, it is nightmare.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

ToddAWalter 316 posts Joined 10/11
07 Nov 2014

Yes it can. But then use of the index will only be made if you write the query to provide the encrypted value for comparison rather than the clear value.
 
WHERE index_field=ENCRYPT_Funct(<value>)
rather than
WHERE index_field=<value>
 
If you do the latter, it will not be able to use the index or at best will have to scan the whole index, decrypting every value to do the matching.

rahuljecbansal 1 post Joined 03/15
10 Mar 2015

which feature may be used to enable data encryption ?
Roles, Profiles, column-level security,  user defined functions (UDF),  X views in the Data Dictionary
 
 

Regards,
Rahul bansal

wmmiteff 20 posts Joined 02/11
10 Mar 2015

Depending on the version of TD you are using, you may be able to collect stats on the expression for the decryption of the column which could help with performance.

--Searching on decrypted index (expression stats)
WHERE DECRYPT_function(index)=<value>

 

You must sign in to leave a comment.