My paper was based around DB2, rather than Oracle, but addresses similar concerns. It is called "Why Does My Job Run Soooo Sloooowly?" and can be downloaded from: http://www.hollandnumerics.com/SASPAPER.HTM

.........Phil Holland

In message <99381968.0308121024.2d5fd9ae@posting.google.com>, Basem <batawfic@yahoo.com> writes >Dear All > >I have to join (equal, left) large oracle database tables with local >SAS dataset. >There is thousands of techniques to do so, Time factor is so critical >for me, is any one aware with SUGI paper or any other paper about that >issue, that is, when to use pass through, when to use "dbkey", >....etc. > >I would also appreciate If anyone face something like that and would >like to share his/her experience. > >Thanks alot

-- -------------------------------------------------------- Holland Numerics Ltd 94 Green Drift, Royston, Herts SG8 5BT, UK mobile : +44-(0)7714-279085 email : <NEWS@hollandnumerics.com> URL : http://www.hollandnumerics.com/ --------------------------------------------------------