Proc Sql Vs Pass thru

[deleted_user]

Hi,

Please help me understand which would to fast to fetch tran level data form Oracle database.

Will there be any differece for the query response time with the facilities available.

Help will be appreciated.

Thanks!
Sridhar.

[Flip]

That will depend on the relative size and tuning of the Oracle vs SAS platforms.

[Doc_Duke]

Passthru gives you explicit control. With the LIBNAME approach to database connections, SAS tries to generate native SQL code that it passes. Sometimes it writes better code than you can, other times not. Sometimes you may inadvertently use a function in SAS that oracle doesn't recognize, so the entire table is pulled to SAS for analysis.

As was mentioned earlier, your mileage may vary.

[ChrisHemedinger]

You might check out the wealth of knowledge in these related papers from SAS:

http://support.sas.com/resources/papers/tnote/tnote_database.html

Chris