Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 10 Dec 2007 @ 08:12:53 GMT


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


Subj:   Workings of TOP n
 
From:   Anomy Anom

<-- Anonymously Posted: Sun, 09 Dec 2007 23:18 -->

We've just upgraded to Version 6.2 and started using new functions such as TOP n.

Can anyone offer any insight into how this function works when the ORDER BY by clause is not used?

It works much faster than sample but seems to return the same result each time so I assume this isn't random. Does it take a sample from a certain amp each time?

Thanks in anticipation



     
  <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