Date: Mon, 29 Jul 2002 13:11:56 -0500
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Rob James <Rob@AECHIDNA.COM>
Subject: Improving SQL performance when data object is a SQL view
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
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)