Hi guys, the user guide says :Each AMP can perform up to 80 tasks in parallel.
who can tell me the meaning of "task", is it a request from users's application such as the select statement or the step within a sql statement?
sorry my english is not very well....i think you should understant what i mean。。。。right?
tasks are so-called AMP Worker Tasks (AWT), the "worker bees" of Teradata.
Each step in Explain will require one or more AWTs to do the work, the number depends on the type of step.
There is an excellent Orange Book from Carrie Ballinger on AWTs and you'll find some blogs from Carrie on this topic, e.g.