Archives of the TeradataForum

Message Posted: Wed, 31 Oct 2012 @ 19:46:30 GMT

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

Soft RI MAY HELP to improve performance with join elimination.

For example

     Table A
     Col1, col2, col3

     Table b
     Col4, col5, col6, col1

     Select a.col1, a.col2
     From A, B
     Where a.col1 = b.col1

If soft RI is defined (with col1 as the foreign key).....Teradata does not need to access table B to satisfy the query. Reduces the over head by eliminating the join.

Ruth Fenwick

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