Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Impact on spool between SELECT TOP and with ORDER BY
 
From:   Singhal, Samipkumar

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016