Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sun, 04 Apr 2010 @ 07:42:17 GMT

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

Subj:   Re: Performance Tunning and Explain
From:   Mistry, Jeetendra

Hi Ahmad,

I don't know what 4 tables are you referring to. But from what I understand this is what I would look out for first

1) Check to see if STATS are collected on the joined tables columns.


You could run the above command before checking the explain of your query - to see the STATS recommended by the optimizer.

2) Check for Big Table - Small Table join scenario.

Normally the small table should be redistributed for the join to happen. Check to see if that is not the case.


Jeetendra Mistry
PS Consultant | Teradata

  <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