Archives of the TeradataForum
Message Posted: Fri, 20 Nov 2009 @ 12:46:42 GMT
| 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
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.