InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 15:46:03 GMT20http://www.teradata.com/teradataforum/Topic12252-9-1.aspxThanksWed, 20 Aug 2008 13:04:00 GMTSireehttp://www.teradata.com/teradataforum/Topic12252-9-1.aspxRelation is 1:MThere is no UPI only PIThanks for your responseRegards,MaheshTue, 05 Aug 2008 10:48:04 GMTSireehttp://www.teradata.com/teradataforum/Topic12252-9-1.aspxHi mahesh,whta is the relation in b/w P_KEY and P_YYMM_DT for both the tables.i.e. it's 1:m ,m:1,1:1 or m:m...............Also in table what is the UPI??????Regards,SubhashThu, 31 Jul 2008 08:01:20 GMTgander_sshttp://www.teradata.com/teradataforum/Topic12252-9-1.aspxHi Experts,I need recommendation for following partitions 1) PRIMARY INDEX TABLE1 ( P_KEY )PARTITION BY RANGE_N(P_YYMM_DT BETWEEN 1001 AND 1002 EACH 1 ,1011 AND 1012 EACH 1 ,1021 AND 1022 EACH 1 ,1031 AND 1032 EACH 1 ,1041 AND 1042 EACH 1 ,1051 AND 1052 EACH 1 ,1061 AND 1062 EACH 1 ,1071 AND 1072 EACH 1 ,1081 AND 1082 EACH 1 ,1091 AND 1092 EACH 1 )PRIMARY INDEX TABLE2 ( P_KEY )PARTITION BY RANGE_N(P_YYMM_DT BETWEEN 1001 AND 1002 EACH 1 ,1011 AND 1012 EACH 1 ,1021 AND 1022 EACH 1 ,1031 AND 1032 EACH 1 ,1041 AND 1042 EACH 1 ,1051 AND 1052 EACH 1 ,1061 AND 1062 EACH 1 ,1071 AND 1072 EACH 1 ,1081 AND 1082 EACH 1 ,1091 AND 1092 EACH 1 )2) PRIMARY INDEX TABLE1 (P_YYMM_DT ,P_KEY )PARTITION BY RANGE_N(P_YYMM_DT BETWEEN 1001 AND 1002 EACH 1 ,1011 AND 1012 EACH 1 ,1021 AND 1022 EACH 1 ,1031 AND 1032 EACH 1 ,1041 AND 1042 EACH 1 ,1051 AND 1052 EACH 1 ,1061 AND 1062 EACH 1 ,1071 AND 1072 EACH 1 ,1081 AND 1082 EACH 1 ,1091 AND 1092 EACH 1 )PRIMARY INDEX TABLE2 (P_YYMM_DT ,P_KEY )PARTITION BY RANGE_N(P_YYMM_DT BETWEEN 1001 AND 1002 EACH 1 ,1011 AND 1012 EACH 1 ,1021 AND 1022 EACH 1 ,1031 AND 1032 EACH 1 ,1041 AND 1042 EACH 1 ,1051 AND 1052 EACH 1 ,1061 AND 1062 EACH 1 ,1071 AND 1072 EACH 1 ,1081 AND 1082 EACH 1 ,1091 AND 1092 EACH 1 )Which partition is recommend for below quires either 1 or 2 SEL *FROM TABLE1A 1A, TABLE1B 1BWHERE 1A.P_KEY = 1B.P_KEYAND 1A.P_YYMM_DT = 1B.P_YYMM_DTSEL *FROM TABLE1A 1A, TABLE1B 1BWHERE 1A.P_KEY = 1B.P_KEYAND 1A.P_YYMM_DT = 1086AND1B.P_YYMM_DT = 1086Thanks in advance,Mahesh.Fri, 25 Jul 2008 16:47:41 GMTSiree