Archives of the TeradataForum

Message Posted: Fri, 13 Jun 2003 @ 13:54:33 GMT

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

Not having V2R5 yet, I am curious. How does the following perform?

Sel a.* from table1 a, controltable b where a.txn_dte = b.dte1;

Yonina Schuchman

_________________________________________________

a) Sel * from table1 where txn_dte = (sel dte1 from controltable);

b) Sel * from table1 where txn_dte between controltable.startdte and controltable.enddate;

Both of these types of request ignore the PPI and revert to a Full Table Scan instead.

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