Hi all I have two queries, one of them perfoms a left join Proc sql, the other one is the same althought its perfoms a right join. the log for both queries are: left join ===== 942 PROC SQL; 943 create table z as 944 select distinct a.*, b.dummy 945 from smalltable as a left join bigtable as b 946 on a.columnname = b.columnname 947 where date = ' '; NOTA: Se ha creado la tabla WORK.z con 12 filas y 5 columnas. 948 quit; NOTA: PROCEDIMIENTO SQL utilizado (Tiempo de proceso total): tiempo real 32:54.51 tiempo de cpu del usuario 19.31 segundos tiempo de cpu del sistema 23.15 segundos Memoria 66927k right join ==== 1016 PROC SQL; 1017 create table z2 as 1018 select distinct a.dummy, b.* 1019 from bigtable as a right join smalltable as b 1020 on a.columnname = b.columnname 1021 where date = ' '; NOTA: Se ha creado la tabla z2 con 12 filas y 5 columnas. 1022 quit; NOTA: PROCEDIMIENTO SQL utilizado (Tiempo de proceso total): tiempo real 8:16.69 tiempo de cpu del usuario 19.42 segundos tiempo de cpu del sistema 20.67 segundos Memoria 66863k I know the second one is much faster than the one with the left join but I don't know how I can explain myseft or my partner. Could anyone light me? Thanks in advanced.
... View more