Archives of the TeradataForum

Message Posted: Thu, 06 Jul 2006 @ 10:49:13 GMT

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

As others already suggested, in teradata materialized views are implemented as a combination of join indexes + normal view definitions. After that you can run the queries on the tables/views (certainly not on the JI) and teradata would internally use the JIs to "cover" the query when possible.

The catch is just that the load utilities are not so sweet on them. And to my knowledge JIs don't allow triggers (seldom used anyway) on them.

Joseph Vinish D'silva

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