MVC Ordering?

Database

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. )

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

Tags (3)
1 REPLY

Re: MVC Ordering?

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