Below delete is consuming 11K CPU.Need assistance to re-write the below delete sql to consume less CPU.

DELETE  FROM IMPORT_REFER_F AA WHERE ( AA.JOB_ID,  AA.JOB_HEADER_ID,AA.JOB_LINE_NUM,AA.JOB_IDN) 

IN (SELECT JOB_ID,JOB_HEADER_ID,JOB_LINE_NUM,JOB_IDN FROM IMPORT_REFER_S BB GROUP BY 1,2,3,4)

Hello,
Is there any way to measure the total AMPCPUTIME consumed by any MLOAD/FLOAD/FEXP job post completion? The values from the dbql(sum of ampcputime for a particular LSN number) does not seem right.
I also tried dbc.acctg. There too, the values seem low.

Good Day Folks...
3 Q's bunched up on stats ...
<> When should you collect Index stats  and column stats for the component columns , both as against just Index stats. How does index stats help and how does stats on component columns that make up the Ix help 

Hello, Everyone

I just want to know if it is normal that executor.exe uses 40% above of cpu.

Hi experts,

I understand that the CPU utilized by a query can be determined by adding AMPCPUTime and ParserCPUTime. If I get a value of 100 does this mean that the CPU was processing the query for 100 seconds? Or is the number represented in some other unit?

I am creating a portlet that will be able to graph certain variables such as delta CPU by user name over a day. I know that I can pull all the session data grouped by user name, but I was wondering if there is a method or DAO that you could recommend that would give me a list of user names for a system.

/usr/tdbms/bin/disstart is permanently using more than 60% of the cpu.
Does anybody experienced the same problem and solved it ?