Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 23 Sep 2005 @ 17:05:38 GMT


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


Subj:   Re: Automated PPI Maintenance
 
From:   Narva, Dan

I can't speak to the two-step process of deleting and then dropping the partition. However,

1. In just recently testing this against a table of similar scale, the single-step process took 5-6 minutes when there was data in the table and a NUSI defined on the table.

2. With no data in a partition the response was almost instantaneous (as Keith reports).

3. Smaller tables with data were not necessarily instantaneous but not very long either.


Keith, are you just using straight SQL to delete the rows (DELETE statement thru SQL Asst or BTEQ), or are you performing an MLOAD delete?


Thanks,

Dan



     
  <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