Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 01 Jul 2013 @ 19:00:57 GMT


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


Subj:   Re: Rowhash Blocking
 
From:   Dieter Noeth

Roopalini Bakthavachalam wrote:

  Can someone please help me understand why there are so many row hash blocking? Could there be any other reason?  


Are the blocks on the actual table being loaded or on a control table?

Could you post the DDL of those tables (at least all indexes/partitioning)? Any triggers/foreign keys?

Is DBQL enabled for those jobs? Check the sequence of statements (especially for those jobs using ODBC with multiple sessions) submitted by the ETL tool.

Which query did you use to determine hash duplicates?


Dieter



     
  <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: 24 Jul 2020