NumOfActiveAMPs - What does a Value of 0 mean?

Database
Enthusiast

NumOfActiveAMPs - What does a Value of 0 mean?

Hello,

What does a value of 0 mean in NumofActiveAmps field in dbc.qrylog?

Thanks

1 REPLY
Teradata Employee

Re: NumOfActiveAMPs - What does a Value of 0 mean?

Hi tdreturn,

    when you find value 0 on the numofactiveAMps field that query did not use any AMPs during its computation.

Check the kind of query and have a look at the requestmode in order to check if that query was really computed ('exec') or just parsed ('prep').

 

Hope this helps.