Archives of the TeradataForum

Message Posted: Thu, 24 Nov 2011 @ 15:45:57 GMT

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

Did you do the following:

1) Primary Index of your new tables should be exactly as the Old table

2) Take Collect Stats on the Primary Index

This will fix your problem.

Cheers

Sobhan

Sobhan Khan
FVP - Teradata/ETL Program
Finance Value Programme

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