|Date: ||Fri, 29 Aug 1997 17:42:26 GMT|
|Sender: ||"SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>|
|From: ||"John Z. Zhao" <jzz@ROCKETS.QUANTUM.EPSILON.COM>|
|Organization: ||Epsilon Data Management|
|Subject: ||Re: Views of Oracle|
Jamie Christopher Michael Beu (firstname.lastname@example.org) wrote:
> I am concerned about the division of labor between Oracle and SAS.
> I have views of Oracle tables, and I need to do some joins and other SQL
> manipulations on the data. However, I need to make sure that SAS alone
> will do the join, and not Oracle. All I expect from Oracle is to just view
> the raw tables, and that's it. Any calculations, manipulations, queries,
> etc. done in the PROC SQL statements must be done using only SAS
> resources. (Oracle will be too busy doing other things.)
> How can I be assured that this will be the case?
> My concerns came about because I thought that I had heard, during the demo
> of SAS, that if PROC SQL is working on a SAS dataset, then SAS will run
> the query. However, if PROC SQL is working on a view of Oracle tables,
> then SAS will do a pass-through of the query to Oracle, and Oracle will
> have to do the actual work and then report the results back to SAS.
> Any and all information you can send my way would be most appreciated.
> Thank you and God bless.
> Jamie Beu (email@example.com) Univ. of Central Florida, Orlando, FL
> "He (Christ) is risen! Alleluia!" (numerous places in the Bible)
> "I'm back on my e-mail again. Praise be to God!"
if your sas views are SELECTION statements agaist signel Oracle tables, then
SAS will do the join if you write PROC SQL two join two or more views
BUT, IF ORACLE COULD DO THE JOINS YOU WANT, IT IS MUCH BUTTER LET ORACLE
DO THE JOINS, MUCH FAST AND SAVE YOUR OVERALL RESOURCES.
Epsilon Data Management
Tel: 617-273-2630 x6219