Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 26 Nov 2011 @ 09:07:14 GMT

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

Subj:   Re: Performance issue due to too many partitions
From:   Machha Narayan Rao Naidu

rishi.agarwal wrote:

  I don't think there will be any performance issue if the data is not available in all the partitions. This is how PPI is creating as we cannot modify the table structure every time to change the range of PPI.  


Thats how Partition works, each partition is a virtual table thus no of partition will not affect but need to make sure not much data goes to UNKNOWN Partition.



  <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