309 Oct 2015 @ 08:46 PDTDatabaseReplyNot Exists vs Left JoinIs Left outer join and not exists produce the same results? I am pretty sure they give different results and if I am wrong please let me know.  
208 Oct 2015 @ 09:48 PDTDatabaseReplyskew factorcould any one please tell how we choose our primary indexes  
106 Oct 2015 @ 02:43 PDTDatabaseTopicupdatting the table with multiple joinsUPDATE t1 r SET r.c1 = (SELECT c.c1 FROM t2 c WHERE r.c2 = c.c2(+) AND c.c3(+)='XX' AND c.c4(+)='XX' AND r.c5 = c.c5(+) AND c.c6(+)='F' r.c7 >=c.c7(+) r.c8 = c.c8...