Archives of the TeradataForum
Message Posted: Fri, 04 Aug 2006 @ 11:35:10 GMT
| 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
| 
