Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 24 Nov 2011 @ 10:38:47 GMT


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


Subj:   Performance issue after splitting the big table
 
From:   rishi.agarwal

Hi,

We have a table that is very big in size ~ 5TB. For maintenance purpose and also to reduce the loading time by parallel loading, we split the tables in 6 parts. We created a view doing UNINON ALL on these 6 tables to access the data. But, after splitting the table, queries are running slow on this view.

Can anyone advise what could be the reason for the same and alternative to handle the situation.


Thanks & Regards

Rishi Agarwal



     
  <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: 27 Dec 2016