×
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.
Yes, different environment. 5250 vs ODBC which is Batch Immediate.
-----Original Message-----
From: Vernon Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxx]
Sent: Friday, June 29, 2018 3:54 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: CURSOR-Table Scan vs Index Scan
Justin
In reply to your earlier bit here - might be different environments - if you run a SELECT interactively, the default goal is to get first IO - if in a batch environment, default goal is to get the whole thing, basically.
So there might be different choices of what is optimum for each - hence, you get a different LF or index used.
Run SQL Scripts is a kind of batch environment, even though you are interactively using it from your viewpoint, right?
At least I think I memrember this correctly!
Cheers
Vern
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
