Archives of the TeradataForum

Message Posted: Thu, 13 Jan 2000 @ 22:29:35 GMT

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

Reading between the lines...

It appears C1 is the primary index for both T1 and T3, and (C1,C2) is the primary index for T2. The following query gives the same results, but may run faster:

     REPLACE VIEW V1(...) AS SELECT ...
     FROM
     (T1 LEFT OUTER JOIN T3 ON T1.C1 = T3.C1)
     LEFT OUTER JOIN T2 ON T2.C1 = T1.C1 AND T2.C2 = T3.C2;

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