All Forums Database
rupert160 131 posts Joined 09/10
04 Jul 2015
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?

Fred 1096 posts Joined 08/04
05 Jul 2015

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

rupert160 131 posts Joined 09/10
11 Jul 2015

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

You must sign in to leave a comment.