Index on Encrypted column

• moorthy.jy

  SSCommitted

  Points: 1753

  More actions

  November 8, 2009 at 10:26 pm

  #385735

  Hi all,

  We have a table with encrypted varbinary (80) column which stores cardnumbers. we have created a view for application which decrypts the cardnumber by DECRYPTBYKEYAUTOCERT function. We do have lots of queries using cardnumbers.

  Is it possible to add index on varbinary column? How do i make the search faster?

  Thanks in advance

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  November 9, 2009 at 9:03 am

  #1076693

  Duplicate post. Please answer here.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question