Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 15 Jun 2005 @ 07:54:06 GMT

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

Subj:   Re: Partition elimination using Date function
From:   Ole Dunweber

Anomy wrote:

  Currently Optimization is not available when we use 'Variables' in a query.  

  Optimizer does not know the value of 'Date', it optimizes as if it is a unknown value. Hence you get All Partition Scan. We can expect this optimization soon.  

Will this optimisation be available in 5.1.2?

In general, I think that "conservative partition elimination" would be better than no partition elimination at all. That is, if it's not possible to determine that we need to retrieve data from exactly these "n" partitions, but it is possible to limit the partitions to say "n+1" or "n+2", I would be very happy with that.


Ole Dunweber
Coop Nordic

  <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