Archives of the TeradataForum

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

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

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.

Regards,

Tomas

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