All Forums Database
nx10204 1 post Joined 06/09
30 Jul 2012
MVC Ordering?

[Teradata 13.1] Why? (CREATE TABLE or ALTER TABLE)

------------------------------------------------------ ------------------------------------------------------ --------------

CCLS_Q DECIMAL(18,0) TITLE '체결수량' DEFAULT 0.,

------------------------------------------------------ ------------------------------------------------------ --------------

ALTER TABLE PD01B.SSD24B_NEW ADD CCLS_Q COMPRESS  (1000,500,300) ;

=>  12.0 : CCLS_Q DECIMAL(18,0) TITLE '체결수량' DEFAULT 0.  COMPRESS (1000. ,500. ,300. )

=>  13.1 : CCLS_Q DECIMAL(18,0) TITLE '체결수량' DEFAULT 0.  COMPRESS (300. ,1000. ,500. )

------------------------------------------------------ ------------------------------------------------------ --------------

ALTER TABLE PD01B.SSD24B_NEW ADD CCLS_Q COMPRESS  (300,500,1000) ;

=>  12.0 : CCLS_Q DECIMAL(18,0) TITLE '체결수량' DEFAULT 0.  COMPRESS (300. ,500. ,1000. )

=>  13.1 : CCLS_Q DECIMAL(18,0) TITLE '체결수량' DEFAULT 0.  COMPRESS (300. ,1000. ,500. )

------------------------------------------------------ ------------------------------------------------------ --------------

ALTER TABLE PD01B.SSD24B_NEW ADD CCLS_Q COMPRESS  (300,500,1000) ;

=>  12.0 : CCLS_Q DECIMAL(18,0) TITLE '체결수량' DEFAULT 0.  COMPRESS (300. ,1000. ,500. )

=>  13.1 : CCLS_Q DECIMAL(18,0) TITLE '체결수량' DEFAULT 0.  COMPRESS (300. ,1000. ,500. )

------------------------------------------------------ ------------------------------------------------------ --------------

stevemogilevski 3 posts Joined 05/12
15 Jan 2013

not sure what are you asking here, but in compressed lists order of values is irrelevant.

You must sign in to leave a comment.