Archives of the TeradataForum

Message Posted: Fri, 27 Jul 2012 @ 10:43:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Sughesh,

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,

Satyendra Kumar

	<Prev	Next>		<<First	<Prev	Next>	Last>>