Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 12 May 2009 @ 12:15:26 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Columns Part of Partitioning Expression
 
From:   Geoffrey Rommel

I can't answer your question, but I wanted to note one thing about your table definition.

     > Column1   INTEGER      NOT NULL      ,...
     > PARTITION BY           RANGE_N(Column1  BETWEEN 200612  AND 200712 EACH 1)

This will create 101 partitions for 200612, 200613, 200614, ... 200699, 200700, 200701, etc. That's probably not what you want, right?

If you need codes in your database to represent months, I suggest something like (year - 1990) * 12 + month. This will fit into a smallint with no gaps between months.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023