Archives of the TeradataForum

Message Posted: Fri, 04 Aug 2006 @ 11:35:10 GMT


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

Subj:		Re: MAXIMUM VERSION NUMBER OF A TABLE

From:		Dieter Noeth

Samarsingh_Chauhan wrote:

I want to know how many times I can change the version number of a table.

Actually we have a scenario where we have to drop secondary index before loading the table and create the index after that. After every drop and creation it increment by 2. Now this process is monthly.. So our concern is whether some maximum limit of version number of a table exists or not?

The datatype of the Version column is smallint, so this is hopefully the limit:

     sel 32767 / (12*2)  as years_if_monthly,
          32767 / (365*2) as years_if_daily;

       *** Query completed. One row found. 2 columns returned.
       *** Total elapsed time was 1 second.

     years_if_monthly  years_if_daily
     ----------------  --------------
                  1365              44

Dieter


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