🚀 go-pugleaf

Ragazzi e' assurdo ... questa query e' un po incasinata ok ma non capisco
perche se come data di inizio e data di fine le metto diverse ci mette 10
secondi a essere eseguita .. se le due date corrispondono quindi mi
riferisco ad un giorno solo ci mette 5 minuti .... e' assurdo,avete qualche
idea???
il Db e' sql server 2000

SELECT MINRITPERTRRS.AGG_CODICE AS AGGNOMEB, (COUNT(MINRITPERTRRS.NUMTRE) -
SUM(TRENIESCD)) AS MIN5
FROM PPOTRENOCIRC INNER JOIN MINRITPERTRRS ON PPOTRENOCIRC.TRR_ID =
MINRITPERTRRS.NUMTRE INNER JOIN (
SELECT *
FROM REP4
WHERE TIPOAGG = 'S') A ON DBO.MINRITPERTRRS.NUMTRE = A.TRENI
AND DBO.MINRITPERTRRS.AGG_CODICE = A.COMP_NOMEB
WHERE (MINRITPERTRRS.MINUTI <= 5)
AND (PPOTRENOCIRC.TRR_CLT_ID IN (
SELECT CLT_ID
FROM PPOCLASSTRENO
WHERE PPOCLASSTRENO.CLT_ID_AGG = 30
OR PPOCLASSTRENO.CLT_ID_AGG = 31))

AND (PPOTRENOCIRC.TRR_DAT BETWEEN CONVERT(DATETIME, '24/07/2002', 103)
AND CONVERT(DATETIME, '24/07/2002', 103))

AND (PPOTRENOCIRC.TRR_TIPO = 'PO') GROUP BY MINRITPERTRRS.AGG_CODICE,
MINRITPERTRRS.AGG_DESCR

UNION

SELECT 'IR' AS AGGNOMEB, COUNT(RITADESPERTRR.
AND_TRR_ID) AS MIN5
FROM RITADESPERTRR INNER JOIN PPOTRENOCIRC ON RITADESPERTRR.
AND_TRR_ID = PPOTRENOCIRC.TRR_ID
WHERE TRR_OPE_COD='001'
AND (RITADESPERTRR.EXPR1 <= 5)
AND (PPOTRENOCIRC.TRR_TIPO = 'PO')
AND (PPOTRENOCIRC.TRR_CLT_ID IN (
SELECT CLT_ID
FROM PPOCLASSTRENO
WHERE PPOCLASSTRENO.CLT_ID_AGG = 30
OR PPOCLASSTRENO.CLT_ID_AGG = 31))

AND (TRR_DAT BETWEEN CONVERT(DATETIME, '24/07/2002', 103)
AND CONVERT(DATETIME, '24/07/2002', 103))
UNION
SELECT 'TT' AS AGGNOMEB, (COUNT(MINRITPERTRRS.NUMTRE) - SUM(TRENIESCD)) AS
MIN5
FROM PPOTRENOCIRC INNER JOIN MINRITPERTRRS ON PPOTRENOCIRC.TRR_ID =
MINRITPERTRRS.NUMTRE INNER JOIN (
SELECT *
FROM REP4
WHERE TIPOAGG = 'S') A ON DBO.MINRITPERTRRS.NUMTRE = A.TRENI
AND DBO.MINRITPERTRRS.AGG_CODICE = A.COMP_NOMEB
WHERE (MINRITPERTRRS.MINUTI <= 5)
AND (PPOTRENOCIRC.TRR_CLT_ID IN (
SELECT CLT_ID
FROM PPOCLASSTRENO
WHERE PPOCLASSTRENO.CLT_ID_AGG = 30
OR PPOCLASSTRENO.CLT_ID_AGG = 31))

AND (PPOTRENOCIRC.TRR_DAT BETWEEN CONVERT(DATETIME, '24/07/2002', 103)
AND CONVERT(DATETIME, '24/07/2002', 103))
AND (PPOTRENOCIRC.TRR_TIPO = 'PO')