Query Tuning

Database
MBR
Enthusiast

Re: Query Tuning

Yes Dieter its the part of daily load from STG to TGT
runtime is 11 AM
and i am not getting what is the cputime?
Ambassador

Re: Query Tuning

Hi MBR,
cputime means the actual CPU seconds used, which is usually extracted from Teradata's query log DBQL.

Dieter
Enthusiast

Re: Query Tuning

Can you paste your SQL (insert and select) may be by which dnoeth can provide you much more explanation.
Fan

Re: Query Tuning

I would also check if the problem is not in the Insert step of the query. TRIMs will definitely burn a lot of additional CPU cycles, but still it should not take that much time to select 210 million rows.

Check the target table PI and SET option.

Cheers,

Igor