Archives of the TeradataForum
Message Posted: Tue, 05 Jun 2012 @ 12:12:41 GMT
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 ...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|