0 - 3 of 3 tags for all amp
All AMP active for Updates based on primary index

Hi All,
I am updating my tables based on primary index, however from the DBQL I see all the amps are active. Could someone explain, if this is expected ?
 
Cannot post the table structre for confidentialy reasons.
But it's like:
MyTable
(Column1 CHAR(10)
,Column2 CHAR(5)
,Column3 INTEGER
....

By ahmed2502, 11 Jul 2014 | Tagged: update primary index all amp | 7 comments
AMP - Storing the Record

Hi There,

If i  have created nupi on the sex column, definatly it has skew ness. Think those two amps are filled (while others are free), we got one more record in to the table. what will happen?
 

My assumption is the record will not insert, as per the rowid/rowhash.
Am i correct?
 

By rajesharra, 08 Mar 2013 | Tagged: all amp | 4 comments
Implementing Tactical Queries in a Mixed Workload Environment

Increasing numbers of Teradata users are introducing tactical queries alongside the more traditional strategic work and near real time data loading ...

By DebraH, 12 Aug 2011 | Tagged: tactical queries mixed workload performance techniques single amp vs. all amp