Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Mon, 10 Nov 2003 @ 17:36:39 GMT





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




Subj:   Removing secondary indexes from table
 
From:   Agarwal, Rachana



Hi All,

I want to remove secondary indexes from a table. The table has around 3 million records in it. I have issued drop index query, but it has been running since 4 hours.

Can anyone suggest a faster way to remove it.

I am not even able to drop that table.


Thanks,

Rachana





     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008