Re: Help with SQL -- MIDRANGE-L

Good News Everybody!

The new search engine is LIVE!

Please report any problems to david (at) midrange.com.

Subject: Re: Help with SQL
From: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
Date: Fri, 17 Jan 2020 12:46:41 -0600
List-archive: <https://archive.midrange.com/midrange-l/>
List-help: <mailto:midrange-l-request@lists.midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.lists.midrange.com>
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>

This is also true - generally speaking interactive will try for faster response, so it gets the first records. Batch tends to go for all.

The only situation that is truly interactive, IMO, is a display session. Running statements in remote connections will tend toward the batch approach.

Vern

On 1/17/2020 12:24 PM, Sam_L wrote:

Digging into my memory, seems to me that the optimizer may decide differently on batch vs interactive execution. but it's been a while...

Sam

On 1/17/2020 11:49 AM, Vernon Hamberg wrote:

I agree with using Visual Explain - it would show any difference in what the optimizer does.

Of course, when the environment changes, the optimizer might make different choices.

Follow-Ups:

Re: Help with SQL , Charles Wilt

This mailing list archive is Copyright 1997-2026 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.