Archives of the TeradataForum
Message Posted: Wed, 17 Jan 2001 @ 16:34:43 GMT
We using Impromptu catalog with our Teradata. The report, the user does, generate a SQL including a OR in the WHERE clause. I know the Teradata ignore the NUPI with a OR.
Does anybody have a idea how force Impromptu to create a good SQL to use the NUPI of the Teradata.
SELECT T1.COL1 (NAMED "c1" ) , T2.COL2 (NAMED "c2" ) FROM "TABLE2" T2 LEFT OUTER JOIN "TABLE1" T1 ON T2."COL3" = T1."COL4") WHERE (1 = 1 AND 25113 = T2.COL5_NUSI OR 1 = 2 AND 25113 = T1.COL6_NUSI ) AND T2.COL7_NUSI BETWEEN 990101 AND 991231
Thank you for your help,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|