Archives of the TeradataForum
Message Posted: Mon, 06 Jun 2005 @ 09:15:33 GMT
We run R5.1.2 and can confirm, that DPE works in some cases. That includes the straightforward case like (PI on PPI-table includes DayId):
select DayId, SUM(Fact) from PPI-table A, Lookup_Day B where A.DayId = B.DayId and B.WeekId = 200520
In other cases our hopes of DPE has not been fulfilled. I'm sorry I haven't got the time to elaborate...
Note, that DPE works for product joins only.
For merge joins, we now get a low of rowkey-based merge joins. This is technically speaking not DPE, but it performs "like-wise", in that it only accesses the relevant part of the PPI-table.
The bottom line is (regarding PPI), that 5.1 is much better than 5.0.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|