Return
-
Title
SELECT DISTINCT JOB_CONTROL FROM CSR_PS_SWAT_OBJ is taking 45% of exec time -
Description
We are showing that the SQL below is taking up about 45% of the execution time in our STAT database. The field seems to be only 0 or 1, so this SQL doesn't make sense but is a massive hog in the system.
SELECT DISTINCT JOB_CONTROL
FROM CSR_PS_SWAT_OBJ
WHERE JOB_CONTROL <> 0
AND JOB_CONTROL <> 1;
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.