Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 20 Nov 2009 @ 12:46:42 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Partition elimination with CAST INTEGER AS DATE
From:   Victor Sokovin

  Has anyone experience the same problem, or is this a bug in 6.2? Or a standard behavior from 6.2 upwards? Or, uhm, did I miss something?  

Martin, I think this is a bug and I think it was introduced in 6.1, which you seem to have skipped by migrating from 6.0 to 6.2.

An enhancement was implemented in 6.1 which was supposed to provide the optimizer with "partition statistics", i.e. partition numbers of rows, so that the optimizer would make its decisions directly on those partition numbers rather than the column values.

I think this is where it goes wrong in your case. Partition statistics is not working correctly with the functions you have described. As the new feature in 6.1 did not come with a warning about this I would qualify this behavior as a defect.


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019