Lentitud en la ejecución de una inst. SELECT.
Publicado por Fabián Tomás de Paula (2 intervenciones) el 05/06/2008 14:24:32
La siguiente instrucción en SQL Server se ejectuta en menos de 6 segundos. La misma instrucción en PostgreSQL me tarda 2 min. 9 seg.. Alguien me puede dar una ayuda de como mejorar la performance de mi SELECT?
SELECT Articulo.IDArticulo, Articulo.descrip, Articulo.Present, Articulo.PrecPubl, CAST('D' AS varchar(1)) AS TipDescEsp, Cabecera_VadxTablas.DescDefa AS Descuento, CAST(0 AS numeric(1)) AS AutEsp, CAST('' AS text) AS Advertencia
FROM Articulo
LEFT OUTER JOIN cabecera_vadxtablas
ON Cabecera_VadxTablas.codigo = 1
WHERE Articulo.TipNacion IN (SELECT Origen FROM detalles_vadxtablas WHERE Codigo = 1 AND Rubro = 0 AND Grupo = 0 AND CodInt = '(NINGUNO)' AND CodLab = 0)
AND Articulo.Rubro IN (SELECT Rubros.cod_rub FROM Rubros INNER JOIN Detalles_VadxTablas ON Rubros.cod_rub = Detalles_VadxTablas.Rubro AND Detalles_VadxTablas.Codigo = 1)
AND Articulo.CodLab IN (SELECT CodLab FROM detalles_vadxtablas WHERE Codigo = 1 AND Rubro = 0 AND Grupo = 0 AND CodInt = '(NINGUNO)' AND Origen = 0)
AND Articulo.AccFarmac IN (SELECT Grupo FROM detalles_vadxtablas WHERE Codigo = 1 AND Rubro = 0 AND CodLab = 0 AND CodInt = '(NINGUNO)' AND Origen = 0)
AND Articulo.IDArticulo NOT IN (SELECT CodInt AS IDArticulo FROM Detalles_VadxTablas WHERE Codigo = 1 AND CodInt <> '(NINGUNO)' AND TipDescEsp <> 'X' AND Grupo = 0 AND Rubro = 0 AND CodLab = 0 AND Origen = 0)
AND Articulo.IDArticulo NOT IN (SELECT CodInt AS IDArticulo FROM Detalles_VadxTablas WHERE Codigo = 1 AND CodInt <> '(NINGUNO)' AND TipDescEsp = 'X' AND Grupo = 0 AND Rubro = 0 AND CodLab = 0 AND Origen = 0)
UNION ALL
SELECT Articulo.IDArticulo, Articulo.descrip, Articulo.Present, Articulo.PrecPubl, Detalles_VadxTablas.TipDescEsp, Detalles_VadxTablas.Descuento, Detalles_VadxTablas.AutEsp, Detalles_VadxTablas.Advertencia
FROM Articulo, Detalles_VadxTablas
WHERE Articulo.IDArticulo = Detalles_VadxTablas.CodInt AND Detalles_VadxTablas.Codigo = 1 AND TipDescEsp <> 'X' AND Detalles_VadxTablas.Grupo = 0 AND Detalles_VadxTablas.Rubro = 0 AND Detalles_VadxTablas.CodLab = 0 AND Detalles_VadxTablas.Origen = 0
ORDER BY Descrip, Present
SELECT Articulo.IDArticulo, Articulo.descrip, Articulo.Present, Articulo.PrecPubl, CAST('D' AS varchar(1)) AS TipDescEsp, Cabecera_VadxTablas.DescDefa AS Descuento, CAST(0 AS numeric(1)) AS AutEsp, CAST('' AS text) AS Advertencia
FROM Articulo
LEFT OUTER JOIN cabecera_vadxtablas
ON Cabecera_VadxTablas.codigo = 1
WHERE Articulo.TipNacion IN (SELECT Origen FROM detalles_vadxtablas WHERE Codigo = 1 AND Rubro = 0 AND Grupo = 0 AND CodInt = '(NINGUNO)' AND CodLab = 0)
AND Articulo.Rubro IN (SELECT Rubros.cod_rub FROM Rubros INNER JOIN Detalles_VadxTablas ON Rubros.cod_rub = Detalles_VadxTablas.Rubro AND Detalles_VadxTablas.Codigo = 1)
AND Articulo.CodLab IN (SELECT CodLab FROM detalles_vadxtablas WHERE Codigo = 1 AND Rubro = 0 AND Grupo = 0 AND CodInt = '(NINGUNO)' AND Origen = 0)
AND Articulo.AccFarmac IN (SELECT Grupo FROM detalles_vadxtablas WHERE Codigo = 1 AND Rubro = 0 AND CodLab = 0 AND CodInt = '(NINGUNO)' AND Origen = 0)
AND Articulo.IDArticulo NOT IN (SELECT CodInt AS IDArticulo FROM Detalles_VadxTablas WHERE Codigo = 1 AND CodInt <> '(NINGUNO)' AND TipDescEsp <> 'X' AND Grupo = 0 AND Rubro = 0 AND CodLab = 0 AND Origen = 0)
AND Articulo.IDArticulo NOT IN (SELECT CodInt AS IDArticulo FROM Detalles_VadxTablas WHERE Codigo = 1 AND CodInt <> '(NINGUNO)' AND TipDescEsp = 'X' AND Grupo = 0 AND Rubro = 0 AND CodLab = 0 AND Origen = 0)
UNION ALL
SELECT Articulo.IDArticulo, Articulo.descrip, Articulo.Present, Articulo.PrecPubl, Detalles_VadxTablas.TipDescEsp, Detalles_VadxTablas.Descuento, Detalles_VadxTablas.AutEsp, Detalles_VadxTablas.Advertencia
FROM Articulo, Detalles_VadxTablas
WHERE Articulo.IDArticulo = Detalles_VadxTablas.CodInt AND Detalles_VadxTablas.Codigo = 1 AND TipDescEsp <> 'X' AND Detalles_VadxTablas.Grupo = 0 AND Detalles_VadxTablas.Rubro = 0 AND Detalles_VadxTablas.CodLab = 0 AND Detalles_VadxTablas.Origen = 0
ORDER BY Descrip, Present
Valora esta pregunta
0