Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 12 Jan 2007 @ 13:04:58 GMT


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


Subj:   Re: ORDER BY in INSERT SELECT to GENERATE Sequence
 
From:   Dan Linstedt

Hi,

Why would you want to do this in Teradata? It is impossible (as far as I know) to do this in Teradata because of the way the Primary Index dictating the order of the via a Hashing Function for parallelism.

In other words, it would be a moot point to "order" the data, because the PI hash would re-order it anyway and re-distribute it.

In Teradata, order by only makes sense when the data will be sent to a client work-station.

Hope this helps,

Dan Linstedt
CTO, Myers-Holum, Inc
www.MyersHolum.com



     
  <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