I am not from MITI, however to my understanding this is not a SQR issue. SQR simply forwards the select statement to the DBS server. In my case it is MS SQL Server. I have used ISQL to optimize queries before by cutting the select statement out of the SQR program and running an interactive SQL statement in Transact SQL or ISQL, (Sorry I don't know what Oracle uses for ad-hoc queries) and looking and the execution plan. Getting working here then transferring the same logic to the SQR Program. Hope this helps Brent btempleton@pmai.org ---------- From: pauldp@SFITVA.CC.FITSUNY.EDU Sent: Wednesday, September 25, 1996 4:48 PM To: Multiple recipients of list SQR-USERS Subject: Re: table joins or separate begin-select clause Could someone from MITI please comment. It's been a rule here to put the table which you expect to get the least number of records from last. It appears to greatly affect performance when you do that. If it has changed (due to Oracle or an SQR upgrade) I'd like to know. If it hasn't, a lot of people might be able to enhance performance. On Wed, 25 Sep 1996, John Douglas wrote: > I vote for biggest table last in the From clause. > > John Douglas > > Lockheed Martin > Diane Paul Fashion Institute of Technology INTERNET ADDRESS PAULDP@SFITVA.CC.FITSUNY.EDU 212-760-7854
Unrecognized Data: application/ms-tnef