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.
| Author |
Topic |
|
kmurlikrishna
Starting Member
23 Posts |
 Posted - 2007-02-24 : 02:18:52
|
| 1) We have SQL Server 2005 on windows 2003 server.2) In some columns of some tables, data is encrypted before being stored and indexes have no meaning against these columns.3) We have decryption views to select all columns of each & every table while decrypting the encrypted ones.4) All our code i.e. only queries is in stored procs. We use only decryption views in these queries.5) When encryted columns are involved in join or filter, query runs very slow and time outs are occuring.6) Indexes on decrypted columns will not work. Can indexes on decryption views against these columns help? If so, how?7) If so, please give an example creation of such an index on a view and its column OR post a good link? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-02-24 : 02:42:43
|
| if you are decrypting your data in the view, what is the point in even encrypting it in the first place? Seems to me that the data should be decrypted at the client instead or hashes should be used.as for speeding up your joins, you may want to consider using a surrogate key instead of the encrypted column(s) in your join.-ec |
 |
|
|
|
|
|
Indexing on Decryption Views