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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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