Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 26 Mar 2002 @ 15:28:14 GMT


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


Subj:   Table partitioning
 
From:   Anomy.Anom

hy all,

has anyone of you made performance experiences with partitioning of a large table into several smaller ones.

example:

a table which holds call detail records for a telecommunication's company has stored 6 months of data in a 600 GB table if we would partition it into 6 separate tables - one for each month - they would have 100 GB each.

if we only query days within one month the response time should of course be faster when we direct it to the right monthly table but if we query days spanned over several month we would have to do it via a view which combines all separate tables with a UNION ALL

the execution plan says it queries all separate tables in parallel is this in your opinion faster than querying the big table?

thanks for any helpful response...

kind regards,

guenter



     
  <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