Sunday, May 29, 2011

how do you you implement Multi valued compression in an existing table?


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.

3 comments:

  1. Sytax is:----
    CREATE TABLE Customer
    (
    Cust_No INTEGER,
    Cust_Name VARCHAR(50) COMPRESS (‘Joe’,‘Mary’),
    Cust_Addr CHAR(200)
    );

    ReplyDelete
    Replies
    1. Thanks for listing out syntax ...

      But Compression cannot be applied on Varchar columns unless you are using latest version --> TD13

      Delete
  2. Yes Vinay, Only version TD13 onwords(TD14) version will Support the MVC on Varchar Column.

    ReplyDelete