Archives of the TeradataForum

Message Posted: Tue, 29 Nov 2011 @ 14:50:18 GMT

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

Hi,

Pls check the Explain plan of the query.. If you find the phrase like 'Assumed to be redistributed ' in the final step

Then pls use the below command before firing the query :

     DIAGNOSTIC STATHASHPART ON FOR SESSION;

Execute your query after firing the above stmnt.. Now the plan sh'ld have changed from 'Assumed to be redistributed '

to just 'redistributed' in the same step where it was as 'Assumed...' earlier. This works only when your source table has some minimal volume of data. If the query processes data in millions, then the above statement will not be of any use.. though there are expected change in the plan..

Regards,

Anusha

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