Please let me know the CPU cycle of a query remain same on different series of Teradata node (say 6x and 1x) or not.
Let's assume I run a query on 6x series. for e.g.
sel * from tab1;
Total CPU (AMPcpu + parseCPU)=100 sec(say)
If I run the same query on 1x series (assume other things are constant like size of table, indexing,skew,ppi,compression, etc.). Will the total cpu cycle be same i.e. 100 sec.
I understand on 6x (powerful machine) the elpased time will be less than 1x.