Archives of the TeradataForum

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

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

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>>