Re: Nodes and AMPs for Query Tuning

The number of AMPS affect the row distrubution of the tables. If you have more number of amps, tables will be more evenly distrubuted as compared to lesser node system. So, if there is an all AMP operation, system with more nodes will perform better as it will be more parallel operation.

Re: Nodes and AMPs for Query Tuning

I would not say that a query will run always better on a System with a higher number of AMPs. If a step is skewed it might be that the skewed AMP runs out of spool space earlier on the system with more AMPs as the total spool is distributed a across all AMPs.