Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Suggestions for Performance tuning?
From:   m n r naidu

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.


Machha Narayan Rao Naidu

  <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