|
|
Archives of the TeradataForum
Message Posted: Wed, 15 Jun 2005 @ 07:54:06 GMT
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.
Regards,
Ole Dunweber
Coop Nordic
| |