Hello together, I implemented the following sql statement (once with "union all" & once with "(full) outer join") with the conditions that turnover of 3 years shall be displayed in three parallel coulumns from the same table in SAS dwh. Es works with "union all" correctly (respectively that data are not on the same level and moreover moved down). With outer join: it seems as follows: //OUTPUT t1.PTN_NR t1.Cust_ID t1.Name_of_Cust Value_Year_1 Value_Year_2 Value_Year_3 100000001 891450001 Schmid 1,50 2,00 10,50 ... SELECT t1.PTN_NR, t1.Cust_ID, t1.Name_of_Cust, sum(t1.Comp_Val) AS Value_Year_1, sum(t2.Comp_Val) AS Value_Year_2, sum(t3.Comp_Val) AS Value_Year_3 From T_Cust_Val_Cas t1 FULL OUTER JOIN T_Cust_Val_Cas t2 ON t2.Cust_ID = t1.Cust_ID FULL OUTER JOIN T_Cust_Val_Cas t3 ON t3.Cust_ID = t2.Cust_ID where /* date-format is dd.mm.yyyy*/ (t1.V_Date_Gen >= intnx('year',today(),-1,'beginning') AND t1.V_Date_Gen < intnx('year',today(),0,'beginning')) OR (t2.V_Date_Gen >= intnx('year',today(),-2,'beginning') AND t1.V_Date_Gen < intnx('year',today(),-1,'beginning')) OR (t3.V_Date_Gen >= intnx('year',today(),-3,'beginning') AND t1.V_Date_Gen < intnx('year',today(),-2,'beginning')) GROUP BY t1.PTN_NR, t1.Cust_ID, t1.Name_of_Cust ; My quesion: how should I tune this query for better performance directly in SQL? Thank you in advande.
... View more