In case you have your own slow SQL query, you can optimize it automatically here.
For the query above, the following recommendations will be helpful as part of the SQL tuning process.
You'll find 3 sections below:
CREATE INDEX acopioci_idx_idcut ON ACOPIOCI (IDCUT);
CREATE INDEX cut_idx_idcut ON CUT (IDCUT);
CREATE INDEX tvc_idx_idtvc ON TVC (IDTVC);
CREATE INDEX viacu_idx_idviacu ON VIACU (IDVIACU);
CREATE INDEX viaiu_idx_idviaiu ON VIAIU (IDVIAIU);
CREATE INDEX registrosimportado_idx_cut ON registrosImportados (cut);
SELECT
registrosImportados.id,
TVC.NOMBRETVC,
VIACU.NOMBREVIACU,
CUT.GLOSA,
registrosImportados.direccion,
dbo.fn_LevenshteinDistance(registrosImportados.direccion,
VIAIU.NOMBREVIAIU,
5)
FROM
ACOPIOCI
INNER JOIN
TVC
ON ACOPIOCI.IDTVC = TVC.IDTVC
INNER JOIN
VIACU
ON ACOPIOCI.IDVIACU = VIACU.IDVIACU
INNER JOIN
VIAIU
ON ACOPIOCI.IDVIAIU = VIAIU.IDVIAIU
INNER JOIN
CUT
ON ACOPIOCI.IDCUT = CUT.IDCUT
INNER JOIN
registrosImportados
ON CUT.CUT = registrosImportados.cut
WHERE
dbo.fn_LevenshteinDistance(registrosImportados.direccion, VIAIU.NOMBREVIAIU, 5) = (
SELECT
MIN(M.DISTANCIA)
FROM
(SELECT
dbo.fn_LevenshteinDistance(registrosImportados.direccion,
VIAIU.NOMBREVIAIU,
5) AS DISTANCIA
FROM
ACOPIOCI
INNER JOIN
VIAIU
ON ACOPIOCI.IDVIAIU = VIAIU.IDVIAIU
WHERE
ACOPIOCI.IDCUT = CUT.IDCUT) AS M)
AND ACOPIOCI.IDCUT = CUT.IDCUT