Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 01 Dec 2011 @ 21:09:20 GMT


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


Subj:   Re: The "Group By" slows down the result in a query
 
From:   Joe Gleason

What version of Teradata are you running? I might be wrong, but I think in TD 13.10 counts are taken from the dictionary which may explain the count performance. Are you applying any kind of a filter to your query? I agree it looks like an Aggregate join index candidate if the cost associated with updates is not too great. Of course it is kind of hard to tell without knowing the pi's, explain, joins, etc.


Joe



     
  <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