|
|
|
Junior Member
 
Group: Forum Members
Last Login: 8/4/2008 9:39:08 AM
Posts: 22,
Visits: 6
|
|
Hi Guru's,
What is the SQL command to create a materialized view in Teradata?.
Thanks in advance,
Stration.
-:-
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 6/9/2008 2:55:55 PM
Posts: 185,
Visits: 2
|
|
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
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 8/4/2008 9:39:08 AM
Posts: 22,
Visits: 6
|
|
Hi Barry,
Yes, I am practicing it in the same way.
Thank you so much,
Stration
-:-
|
|
|
|