Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 Jan 2011 @ 09:49:08 GMT


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


Subj:   Re: Questions including Performace tuning
 
From:   Minakshi Swami

Hi,

Below are few point for performance and tuning

1. collecting statistics

2. Explain Statements

3. Avoid Product Joins when possible

4. select appropriate primary index to avoid skewness in storage

5. Avoid Redistribution when possible

6. Use sub-selects instead of big "IN" lists

7. Use derived tables

8. Use GROUP BY instead of DISTINCT ( GROUP BY sorts the data locally on the VPROC. DISTINCT sorts the data after it is redistributed)

9. Use Compression on large tables


Thanks

Minakshi Swami



     
  <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