hidrau
asked on
query is slow returning the result
Hello guys,
I have this query in access and it is slow to return the result.
I added some index but I could notice that its performance was not satisfactory.
CESTPAL has 880 rows
CADPAL has 7500 rows
Is there another way to do it where I can improve the result speed?
SELECT COUNT(*) AS TOTAL
FROM CADPAL AS A
WHERE A.CP_CODIGO IS NOT NULL
AND (A.CP_CODUSO="SI" OR A.CP_CODUSO='20')
AND EXISTS (Select C.CS_CODPAL FROM CESTPAL C
Where (C.CS_CODUSO="SI" or C.CS_CODUSO='20')
and A.CP_CODIGO = C.CS_CODPAL
And C.CS_CODCESTA=51
);
I have this query in access and it is slow to return the result.
I added some index but I could notice that its performance was not satisfactory.
CESTPAL has 880 rows
CADPAL has 7500 rows
Is there another way to do it where I can improve the result speed?
SELECT COUNT(*) AS TOTAL
FROM CADPAL AS A
WHERE A.CP_CODIGO IS NOT NULL
AND (A.CP_CODUSO="SI" OR A.CP_CODUSO='20')
AND EXISTS (Select C.CS_CODPAL FROM CESTPAL C
Where (C.CS_CODUSO="SI" or C.CS_CODUSO='20')
and A.CP_CODIGO = C.CS_CODPAL
And C.CS_CODCESTA=51
);
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks,
I changed my code.
I changed my code.
Thanks, glad I could help. As you can see, a subquery slows things down.
ASKER
I am using exists, what is faster "in" or "exists"?