Archives of the TeradataForum

Message Posted: Thu, 07 Jun 2012 @ 22:14:47 GMT

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

Hi ,

What is the difference between Select top 200000 colnames from tablename and select top 20000 colnames from tablename order by colname if we consider spool...

Which query should take more spool ?

I am aware first one gives top 2lakh based on row hash and another based on colname ...

Regards ,

Samip

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