Archives of the TeradataForum

Message Posted: Wed, 07 Sep 2005 @ 22:56:57 GMT

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

Dave,

it's not a myth, it happens.....shouldn't but it does. And it's a bug.

My example was even more simplistic, joining two tables, one a one row, one column current_month table, the other very large....

     SELECT pi_col1 , colx
     FROM ddwta.big_table a,
     ddwta.current_month b
     WHERE a.pi_col1 = 123456
     AND a.pi_col2 = b.snap_dt ;

if the big table was listed first, scan of the big table, if little table first, PI look-up to big table...big difference in performance....sub-second vs. minutes....

We're on 5.1.1 and the DR opened is 94901

Ruth Fenwick
Database Services
Royal Bank of Canada

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