I work on SQL server 2012 I need to search on table partswithcompany that have 40 million rows .
when make select SearchParts, CompanyId from partswithcompany where CompanyId=1234 and SearchParts='A5ghf7598fdmlcpghjk'
it is very slow to re but it take too much long time when make select data from table or when using where condition is also very slow
so i think more then i get idea to use hash byte column so How to do that please ?
if you have any good idea to enhance performance i can accept it