Performance Tuning in Teradata

Hi ,

When playing with data and storing a lot of data in tables . Most of the time in the career playing with data , this is an important role that would be played –performance tuning . Also , this is a most important question that would be asked in any interview. High level the steps are to understand where the bottleneck is and try to improve the performance of the query.

The different methods to improve the performance of a query

  • Collect Stats of the table
  • Create indexes on the columns used on joins
  • Run the explain plan and check where the cost is high and try resolving for it.

 

The third point there are different syntax for different database and below is for Teradata.

 

DIAGNOSTIC HELPSTATS ON FOR SESSION;
EXPLAIN select * table_name;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s