Archives of the TeradataForum

Message Posted: Wed, 15 Dec 2010 @ 11:31:07 GMT

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

Anusha,

There wont be any improvement as

     COUNT(*) OVER (ORDER
     BY TBL3.ID ASC ROWS UNBOUNDED PRECEDING )  CNT

     ROW_NUMBER() OVER (ORDER BY TBL3._ID)  ROW_NR

Functions in same ,moreover the running time usually would be same .

Try creating partition primary index on target table with range_n over the count of column during insert .

Eg.

     Partition by range_n(countinsert between 1 and 200000 , no range or unknown
     )

Or create a partition on base table TBL3.ID

     Partition by TBL3 .

This should certainly improve the performance

Regards,

Anshuman Singh
Cognizant

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