× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. January 2020

Re: Help with SQL

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-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.