Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


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

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