Date:         Mon, 29 Jul 2002 13:11:56 -0500
Reply-To:     Rob@aechidna.com
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Rob James <Rob@AECHIDNA.COM>
Organization: Aechidna
Subject:      Improving SQL performance when data object is a  SQL view
In-Reply-To:  <0H0000GK4VI47O@l-daemon>
Content-type: text/plain; charset=US-ASCII

I have a view with ~1.6M records made up of a union join of
several indexed tables. I am not happy with the
performancem but it could be hardware related. I would
like to minimize the software/RAM-dependent components.
I shall have to live with the disk drive limitations for the
time-being/

I see from SAS-L traffic that I can improve performance
within PROC SQL with RESET BUFFSIZE statements, but what
about when I am accessing the view via a proceudre e.g.
Proc Freq? Experimentation with system options such as
BUFSIZE, BUFNO, etc. did not get me very far. I would
welcome suggestions (SAS8.2 on an aging NT box)

Thanks,

Rob