All Forums Database
sethiyagu 19 posts Joined 11/04
22 Feb 2006
Materialized view in Teradata

Hi Guru's,What is the SQL command to create a materialized view in Teradata?.Thanks in advance,Stration.

Barry-1604 176 posts Joined 07/05
22 Feb 2006

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

sethiyagu 19 posts Joined 11/04
23 Feb 2006

Hi Barry,Yes, I am practicing it in the same way.Thank you so much,Stration

You must sign in to leave a comment.