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
create table #partswithcompany
insert into #partswithcompany (SearchParts,CompanyId)