Number of AMP's in Teradata

How to get no. of AMP's in Teradata? It's smple, just run the below query:

SELECT HASHAMP ( );

As AMP's start from 0, you have to add 1

SELECT HASHAMP ( ) + 1;

Related Posts