Archives of the TeradataForum

Message Posted: Fri, 08 Jun 2012 @ 09:08:02 GMT

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

Todd,

Thanks for your suggestions .

What I am unable to understand is why the query without order by clause is spooling out and the one with order by is not ....as when we give order by clause it needs complete sorting ...but the one without the clause will give the values just based on Row hash values ...

Regards,

Samip Singhal
Managed Services | Americas Development Center Teradata India Pvt. ltd.

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