Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 04 Feb 2011 @ 20:43:03 GMT


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


Subj:   Re: Avoid distinct
 
From:   Woodrow, Steven

The last I heard, and granted it was awhile ago, there were differences even in 13.

I believe the rewrite will NOT occur if there exists a "With" , "Having", "Sample", "Random" or "order by" clause for instance.

My notes also have something about this rewrite not occurring if there are aggregrations or OLAP in the assign list.

Hopefully, someone will correct me and tell me this is wrong. . . .



     
  <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