complete table on one AMP possible

[karacharlie]

Hi,
is it possible to force the TeraData system to store a complete table on one AMP by index choice?
If yes, can this be an advantage?
system: 400 AMPs
table : few rows

 

[BillDHS]

You could put a constant in the table and use it for the primart index.

create table xxxx
(col1 int,
col2 CHAR(20))
primary index(col1);

Insert into xxx
select 4,
cola
from tableb ;

I can't think of any particular advantage of a one AMP table. You MUST collect statistics on the small table to make sure Teradata uses big table- small table join logic when this table is joined to other tables. It will than be duplicated on all AMPs, rather than redistributing a larger table.