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;
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Stat
