Re: SQL and UNION: why do some UNIONs significantly inflate the processing time, while others don't? -- MIDRANGE-L

Subject: Re: SQL and UNION: why do some UNIONs significantly inflate the processing time, while others don't?
From: "James H. H. Lampert" <jamesl@xxxxxxxxxxxxxxxxx>
Date: Fri, 21 May 2021 17:05:21 -0700
List-archive: <https://archive.midrange.com/midrange-l/>
List-post: <mailto:midrange-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/midrange-l>, <mailto:midrange-l-request@lists.midrange.com?subject=unsubscribe>

On 5/21/21 9:25 AM, Charles Wilt wrote:

You should have ACS. Most of it doesn't require a license.
I believe only 5250 and data transfer portions require a license.

I'm beginning to see some merit in that idea, at least where Visual Explain is concerned.

I'm not entirely clear on how one gets ACS, these days. And will it run on a Mac? And (here's the important part) how much trouble is it to set up a connection to any arbitrary customer box?

--
JHHL

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: SQL and UNION: why do some UNIONs significantly inflate the processing time, while others don't? , Mark Waterbury
RE: SQL and UNION: why do some UNIONs significantly inflate the processing time, while others don't? , Rob Berendt
Re: SQL and UNION: why do some UNIONs significantly inflate the processing time, while others don't? , Vern Hamberg

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.