Re: sql - why doesn't the query engine know this???

He is using the "like" feature and that could be causing the system to rebuild new access paths, hence the delay.

Sent from my iPad

On Jun 19, 2015, at 10:05 AM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

On Fri, Jun 19, 2015 at 9:15 AM, Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx

wrote:

that has been the history of this query... most days it runs in 1 second,
but every now and then (appears to be if we have had heavy activity on the
BOM file)
the jobs takes 30 to 45 minutes...

​That almost sounds as if a access path (logical file) the QE was making
use of has MAINT(*REBUILD) or MAINT(*DLY)...

I didn't think the QE would bother with such an access path...but I don't
know.


Charles
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.