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


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


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