Archives of the TeradataForum
Message Posted: Mon, 01 Jul 2013 @ 19:00:57 GMT
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
|