Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 27 Aug 2008 @ 12:37:30 GMT


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


Subj:   Running query without using partition on a partition defined column
 
From:   chinmay.das

Hi,

Please give your suggestion on the partition concept without using partition defined column how do we run sql in the optimized way?

Following is the query

     SEL ,
             ,

     FROm
             

     INNER JOIN
             

     ON
     TAB1. =TAB2.
     AND
     TAB1. IN (SEL  FROM  GROUP BY 1)

We have partition on the TAB1.<col2> column when we use the hard coded date values in the IN clause query run with in 30 sec but needed above mentioned subquery that time taking long time more than 10 min. What is other best way to write this sql?

Thanks in advance


Regards

Chinmay



     
  <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: 27 Dec 2016