Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 22 Sep 2004 @ 15:42:48 GMT


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


Subj:   Re: Dropping a secondary index during an INS/SEL
 
From:   David Wellman

Hi,

No you can't. The Insert will have locked the table for Write, which means that any DDL statement (e.g. "Drop Index") will wait on the lock.


Cheers,

Dave



     
  <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