Archives of the TeradataForum

Message Posted: Wed, 23 Mar 2011 @ 11:42:39 GMT

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

HI Samikkumar,

Performance Tuning is a vast Subject which need high Expertise in SQL and system Behavior,

You can do,

1. Check the Joins used in complex Queries ( Joining a Huge Table with a small one will cause Product Joins).

2. Check for a good Primary Index and Data in Primary Index Columns( Joining two table which don't have same Primary Index type causes Data Distribution).

3. Check the Data in the tables ( Some times we are Joining the Query which has Most number of Nulls which should be avoided).

4. Most of the times Multi column stats which are recommended will not help in Query Performance.

Above are Few Points which we can check in our Primarily Investigation.

Looking for some other Good Suggestions from Experts.

Thanks

Machha Narayan Rao Naidu

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