Pergunta de entrevista da empresa Lidl

What do you do if you have long running SQL queries?

Resposta da entrevista

Sigiloso

22 de fev. de 2021

I use SQL Server estimated execution plan to find out why the query is taking so long, if we are missing indexed, if the query is performing index scans instead of index seeks etc.