Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Column level encryption and Indexes

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2011-06-21 : 11:17:16
I somewhere read that the indexes on encrypted columns are not useful, since all searches result into table scans.

Is that a true statement?
Why the indexes on a encrypted column becomes useless?


------------------------
I think, therefore I am - Rene Descartes

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-06-21 : 11:37:58
Have a look at http://msdn.microsoft.com/en-us/library/cc278098(v=sql.100).aspx
Go to Top of Page

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2011-06-21 : 12:09:28
Thank you Russel. That helped.

------------------------
I think, therefore I am - Rene Descartes
Go to Top of Page
   

- Advertisement -