Need high performance View


Need high performance View

I've been given the onerous task of having to replace a set of ETL queries (which create tables) with Views. In this manner, we can kill the ETL processes and not worry about "syncing" with the source tables that are the basis for the underlying data. Plus, we eliminate the redundancy.

Knowing that Teradata does not have materialized views, what's the best approach as I am worried about performance ?

Temporal Tables ?

Views that implement the "AS OF" feature ?

The data of course will be "versioned" (i.e. slowly changing dimensions) and the "AS OF" feature seems to address that directly.

Any advice greatly appreciated !!