Performance when comparing Varchar fields in SQL Server

Question

Performance when comparing Varchar fields in SQL Server

Navigation

#1 by (0 votes)

0

% w / o% down is causing a lot of slowness because I use

Right(L.nrDiscado, Len(D.Descricao))

(I believe) to compare with the SQL field:

create table #TempNrDiscado (NrDiscado varchar(150))

Insert into #TempNrDiscado
Select distinct L.nrDiscado from #TempLigacoes L with(nolock) 
   inner join GI_Dispositivo D with(nolock) on  
      Right(L.nrDiscado, Len(D.Descricao)) = D.Descricao

Does anyone know of any way I could make this comparison?

Note: If I put a number 10 in place of D.Descricao it goes fast .

sql desempenho

asked by anonymous 27.12.2016 / 13:33

1 answer

Primefaces generating primefaces.css.html file How do I resolve the distortion that occurs when I switch the portrait to landscape app?

score 0 · Answer 1

I solved this by having to work with some temporary tables in order to get a single value to do the JOIN instead of the Right (L.nrDiscado, Len (D.Descricao)) as said here that causes a lot of slowness. >

The question of working with the key as it has been said here is also not possible in this case, because the way information is linked is only this way.

Thank you all for the help!