您好各位大大,

我想问一下各位大大,如果我需要使用2个Table来做分析及资料库容量太大,我
想改善Joining 的速度,  是否将他们先由Oracle抽出2个Table 再在SAS中join 会加快产生结果?

原本 － 由Oracle Join

Select A1.A  ,A1.B_String, A1._Date,..(如下二十多) ,
      B1.A, B1.B_String ,B1.(如下二十多)
From A as A1 B as B1 where
(A1.B_String=B1.B_String) and (A1.Date between ‘1/1/2000’ and 30/6/2000’)


由Oracle 分拆2个table 再 join ?

A:
Select A1.A, A1._Date From A as A1 where  (A1.Date between ‘1/1/2000’ and 30/6/2000’)
B:
Select B1.A, B1.B_String ,B1 From B as B1

…sort….

Merge A B by String ;