Archives of the TeradataForum

Message Posted: Fri, 20 Oct 2006 @ 14:37:57 GMT

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

I have found that creating an index on the join index, then collecting stats on the index has greatly improved the utilization of the JI by queries.

While the idea of creating an index on a join index might seem odd, it's really just an exercise of creating an index on a system maintained summary table.

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