Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 22 Sep 2004 @ 15:26:55 GMT


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


Subj:   Dropping a secondary index during an INS/SEL
 
From:   Desarrollo.ProyectoSinemax

Dear all:

There is an insert select operation on a non-empty table wich is taking too long. The target table has two secondary indexes.

Question: Can we drop the secondary indexes while the insert-select is in progress ?

We wan to speed up the insert-select. A rollback will have devastating efects in our datawarehouse. Our is a 4950 environment 4 nodes with 2R.04.01.03.40 Teradata RDBMS


Any help will be highly appreciate

Thanks in advance.



     
  <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