Re: Help with SQL -- MIDRANGE-L

Subject: Re: Help with SQL
From: Sam_L <lennon_s_j@xxxxxxxxxxx>
Date: Fri, 17 Jan 2020 13:24:35 -0500
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>

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.

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Help with SQL , Vernon 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.