Archives of the TeradataForum
Message Posted: Thu, 13 Jan 2000 @ 22:29:35 GMT
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;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|