Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 08 Sep 2016 @ 19:30:30 GMT


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


Subj:   Skewed Delete Query
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, September 08, 2016 09:54 -->

Dear Forum,

Is there a better way to rewrite the below query?

This delete is skewed and the impact cpu is at least 50 times more than the sum(cpu).

     DELETE FROM
     DB1.TAB1_stg? A
     DB1.TAB2 B
     WHERE A.id=B.id
     AND A.Y1=B.Y1
     AND A.Z1=B.Z1
     AND A.XYZ=B.XYZ
     AND A.PQR=B.PQR
     AND A.MNO=B.MNO
     AND A.DATE < B.DATE
     AND A.IJK=B.IJK


     tab1_stg:  PI: ( id ,y1 ,z1 ,xyz ,pqr );  - Stage table.
     Count - 5million

     Tab2:  PI: id
     count - 300million

Both the tables are slightly skewed.? Stats are existing on PI and join columns.

Is there a better way to rewrite this query or should the PI of stage table be same as tab2 or viceversa as the structure of both the tables is same?

Appreciate your response!



     
  <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