Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 05 Sep 2011 @ 13:49:33 GMT

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

Subj:   Re: Need performance help with update
From:   Gorner, Tomas

Hi Ashish,

can you please provide the DDL of the tables, especially the target? In general, updating an index is very consuming. This might be your problem.

When you update a column from primary index, the table needs to be rehashed after each updated row. Not something you want to do.

Similiarly, secondary index updates tend to be resource-consuming for larger tables.



  <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