referencing page 44 of the teradata 13.10 release summary, I noticed a new functionality that is difficult to conceptualise in how it achieves this:
CREATE JOIN INDEX fin_idw.testdate_idx as
where d1 < current_date
does anybody know how it does this under the hood? Can somebody explain what it does?
CURRENT_DATE is initially resolved at CREATE time. Afterwards, you periodically would use new ALTER ... TO CURRENT functionality shift the date range.