Archives of the TeradataForum

Message Posted: Mon, 07 Sep 2009 @ 13:52:00 GMT

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

Hi All,

Thanks everyone for sharing such a good explanation. I try many workaround to overcome the ORDER BY issue, but I could not. Hence I change the logic in our application code by removing the ORDER BY clause. Now, I'm not using "INSERT INTO ....SELECT .... ORDER BY", I'm first fetching the records with ORDER BY and then inserting to the table using bulk insert option (which is a performance problem but can be managed).

Thanks for all your help.

Shrihari Saraf

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