Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 25 Nov 2011 @ 09:07:13 GMT


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


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

Hi Janardhan, Todd

Main reason behind splitting was to ease the maintenance activities like STATs collection, on the table as the table is very huge. Moreover, same data is coming from multiple sources, thus I can reduce my ETL time with data going in separate physical tables. PPI is already available on DATE & REGION. We have two categories of users -

a) who access data for all regions

b) access data for specific region only.


In case of (b), PPI will help but in case of (a), data is required to be accessed for all regions, hence all tables are required, Here PPI also won't help. Do we have any alternative or better approach in Teradata to handle such cases of dealing with large tables.


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: 15 Jun 2023