Join indexes with Curent_date or Current_timestamp

Database

Join indexes with Curent_date or Current_timestamp

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
SELECT *
from fin_idw.testdate
where d1 < current_date
;

does anybody know how it does this under the hood? Can somebody explain what it does?

Tags (2)
2 REPLIES
Teradata Employee

Re: Join indexes with Curent_date or Current_timestamp

CURRENT_DATE is initially resolved at CREATE time. Afterwards, you periodically would use new ALTER ... TO CURRENT functionality shift the date range.

Re: Join indexes with Curent_date or Current_timestamp

That makes sense. So it needs to be part of a batch process each :) thanks fred!