Archives of the TeradataForum
Message Posted: Fri, 27 Jul 2012 @ 10:43:31 GMT
There is no such concept in the materialized view directly in TD, but we can achieve it using Join Index.
As you might be aware with view that it is nothing but the replica of table/tables created for specified purpose.
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.
Thanks and Regards,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|