CONNECT TO viperdb  USER gexadm USING *******;

CREATE TABLESPACE TSMDC
PAGESIZE 4K 
MANAGED BY DATABASE
USING (FILE 'F:\VIPERDB\tsmdc'  10  M )
AUTORESIZE YES
INCREASESIZE  10  M 
MAXSIZE NONE;

CREATE TABLESPACE TSMDCPART
PAGESIZE 4K 
MANAGED BY DATABASE
USING (FILE 'F:\VIPERDB\tsmdcpart'  10  M )
AUTORESIZE YES
INCREASESIZE  10  M 
MAXSIZE NONE;

CREATE TABLESPACE TSMDCPARTCOMP
PAGESIZE 4K 
MANAGED BY DATABASE
USING (FILE 'F:\VIPERDB\tsmdcpartcomp'  10  M )
AUTORESIZE YES
INCREASESIZE  10  M 
MAXSIZE NONE;

CREATE TABLE VIPER.TAB_MDC
 (NOD         DECIMAL( 3 ,  0 ),
  ROAD        DECIMAL( 3 ,  0 ),
  CARS        DECIMAL( 7 ,  0 ),
  RPS         DECIMAL( 3 ,  0 ),
  DATEMODIFY  DATE
 )
 IN TSMDC
 ORGANIZE BY DIMENSIONS (NOD,ROAD); 

CREATE TABLE VIPER.TAB_MDC_PART
 (NOD         DECIMAL( 3 ,  0 ),
  ROAD        DECIMAL( 3 ,  0 ),
  CARS        DECIMAL( 7 ,  0 ),
  RPS         DECIMAL( 3 ,  0 ),
  DATEMODIFY  DATE
 )
 IN TSMDCPART
 PARTITION BY RANGE (DATEMODIFY)
   (STARTING '2002-12-01' ENDING '2006-09-30' EVERY  1  MONTH)
 ORGANIZE BY DIMENSIONS (NOD,ROAD);  

CREATE TABLE VIPER.TAB_MDC_PART_COMP
 (NOD         DECIMAL( 3 ,  0 ),
  ROAD        DECIMAL( 3 ,  0 ),
  CARS        DECIMAL( 7 ,  0 ),
  RPS         DECIMAL( 3 ,  0 ),
  DATEMODIFY  DATE
 )
 IN TSMDCPARTCOMP
 PARTITION BY RANGE (DATEMODIFY)
   (STARTING '2002-12-01' ENDING '2006-09-30' EVERY  1  MONTH)
 ORGANIZE BY DIMENSIONS (NOD,ROAD)
 COMPRESS YES; 

LOAD FROM viper.test.del OF del MESSAGES tab_mdc.IMP 
INSERT INTO VIPER.TAB_MDC;

LOAD FROM viper.test.del OF del MESSAGES tab_mdc_part.IMP 
INSERT INTO VIPER.TAB_MDC_PART;

LOAD FROM viper.test.del OF del MESSAGES tab_mdc_part_comp.IMP 
INSERT INTO VIPER.TAB_MDC_PART_COMP;                      

REORG TABLE VIPER.TAB_MDC_PART_COMP RESETDICTIONARY;
 

CREATE TABLE VIPER.TAB_COMP
 (NOD         DECIMAL( 3 ,  0 ),
  ROAD        DECIMAL( 3 ,  0 ),
  CARS        DECIMAL( 7 ,  0 ),
  RPS         DECIMAL( 3 ,  0 ),
  DATEMODIFY  DATE
 )
 IN TSCOMP
 COMPRESS YES;  

DATABASE: VIPERDB                                                             
VERSION : SQL09010                                                            
 2006 - 09 - 21 - 08 . 28 . 11 . 671000                                                     
                                                                              

Action: ROWCOMPESTIMATE TABLE
Schema name: VIPER   
Table name: TAB_COMP
Tablespace ID:  9   Object ID:  4 
Result file name: vipercomp
 
    Table phase start (ID Signed:  4 , Unsigned:  4 ; Tablespace ID:  9 ) : VIPER.TAB_COMP
     
      Data phase start. Object:  4   Tablespace:  9 
      Row compression estimate results:
      Percentage of pages saved from compression:  36 
      Percentage of bytes saved from compression:  36 
      Percentage of rows ineligible for compression due to small row size:  0 
      Compression dictionary size:  57088  bytes.
      Expansion dictionary size:  32768  bytes.
      Data phase end.
    Table phase end.
Processing has completed.  2006 - 09 - 21 - 08 . 28 . 25 . 156000