Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 31 Jan 2002 @ 12:24:57 GMT


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


Subj:   Sequences
 
From:   Wicznowski Axel

Hello,

in oracle there are constructs called sequences. Is there something similar in TD? I have some table and want to count one column up with every insert. Are there some other possibilities than using insert into tab (id, ...) select max(id)+1, ... from tab or Triggers? They all take too long on large Tables.


Mit freundlichen Gruessen / Best Regards

Axel Wicznowski

MGI
METRO MGI INFORMATIK GMBH
Duesseldorf, Germany



     
  <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