MVC can be implemented on following conditions
1. A new column with multi valued compression can be added to an existing table, but cannot modify existing compressed column.
2. Create a new table with column which has MVC and do insert .. select from original table
Or
CREATE TABLE... as with column designated MVC.
Sytax is:----
ReplyDeleteCREATE TABLE Customer
(
Cust_No INTEGER,
Cust_Name VARCHAR(50) COMPRESS (‘Joe’,‘Mary’),
Cust_Addr CHAR(200)
);
Thanks for listing out syntax ...
DeleteBut Compression cannot be applied on Varchar columns unless you are using latest version --> TD13
Yes Vinay, Only version TD13 onwords(TD14) version will Support the MVC on Varchar Column.
ReplyDelete