Materialized view in Teradata

Database
Enthusiast

Materialized view in Teradata

Hi Guru's,

What is the SQL command to create a materialized view in Teradata?.

Thanks in advance,
Stration.
2 REPLIES
Enthusiast

Re: Materialized view in Teradata

There is no such thing as a "materialized view" in Teradata.

The equivalent in Teradata would be a join index (or aggregate index) with a corresponding view put on top of it. The command to create one is "CREATE JOIN INDEX...(lots of options)".

Join indices are maintained when the data is maintained. They cannot be accessed directly, but are invoked when the optimizer determines it is beneficial. Even though you cannot invoke a join index directly, you create a view that looks like the join index and in that way, it would be similar to having direct access. However, this approach does not guarantee that the join index will be used.

Barry
Enthusiast

Re: Materialized view in Teradata

Hi Barry,

Yes, I am practicing it in the same way.

Thank you so much,
Stration