Archives of the TeradataForum

Message Posted: Tue, 22 Jul 2003 @ 16:17:34 GMT

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

Hi LeBlanc,

We insert and update 3000 + rows in 4-5 tables after manipulating data. For data consistency we make auto commit false and this executes in one transaction . There are some places in application when updating table primary index is not handy. Even due to business requirement cant define unique primary index. In special cases duplicate primary indexes are more than 100.

We use 2 node machine and its testing environment.

Yes thats true success for application will depend 60% on design thats why I told him some points to consider while he start design.

Thanks,

Pradeep

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