Teradata performing fine tuning

Teradata Applications
Teradata Employee

Teradata performing fine tuning

Hi,

 

I'm trying to tune a query which has a column AERCL_CD in the IN LIST containing huge amount of Value~2B Rows.As per my Observation,the query is performing badly due to huge amount of data available in the In List for AERCL_CD .i tried to create a secondary index for the column but due to huge amount of rows,the query is not picking the secondary index.can any advice on how to tune this query.is there any other approach to tune.Please suggest!!

3 REPLIES
rjg
Supporter

Re: Teradata performing fine tuning

A couple of first thoughts:

Is the column value skewed? 

Are statistics current?

Is the datatype the same as that being compared?

 

Rglass

Teradata Employee

Re: Teradata performing fine tuning

Thanks for your prompt response!!

PFB the my response to your qestions:

 

Is the column value skewed? 

yes,the column is highly skewed.it contains 2B rows for the value('01')(used in the IN List).

 

Are statistics current?

 

Yes,the Stats are Current.

 

Is the datatype the same as that being compared?

 

Yes,the Datatype is same as being Compared.

 

Please suggest how to proceed on this.

 

 

 

Teradata Employee

Re: Teradata performing fine tuning

Hi,

 

Can anyone assist me here.