|
Is there a performance difference between oracle via libname (sas/access) and using proc sql to do sql - pass-through ? |
|
It depends on many factors, but I've found pass-through queries generally return results faster because they push the processing to the database and then return the results only, in contrast to the alternative in which many rows are are returned to be processed on the machine where SAS is running. |
|
Rich is correct to some degree. With each new version of SAS, however, they have been making the However, if you want to do something very "Oracle-like" and use Oracle SQL constructs that are not present in SAS, then you'll have to use Pass-through. For example, Index "hints" syntax can be used in pass-through that can't be used via So bottom line, if its simple SQL, then |
|
Not a precise answer to the quesiton, but if you do see a bit difference between passthrough performance and sas/access libnames then you can use options sastrace=',,,d' sastraceloc=saslog nostsuffix;to find out exactly what SQL is being generated (and options sastrace=none;to turn it off again). You may also see different results depending on whether you use the ODBC or ORACLE engines for your libnames. |
