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.
Posted by at

3 comments:

  1. ManjunathNaik.M.CMay 10, 2012 at 7:52 AM

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

    ReplyDelete
    Replies
    1. VinayMay 10, 2012 at 7:58 AM

      Thanks for listing out syntax ...

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

      Delete
  2. ManjunathNaik.M.CMay 15, 2012 at 7:16 AM

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

    ReplyDelete

Subscribe to: Post Comments (Atom)