Re: Embedded SQL/Index/Speed/How

Thank you Rob...I thought it was something like this, but wasn't sure
where to look.

So if I have the index on the system, and then IPL, the first time the
program is run it will re-cache the plan, correct? Then every run
after the first will be fast. Am I thinking about this correctly?

Argh...it's a view, not an index. Is that still kept in the cache?

On Wed, Mar 23, 2011 at 12:56 PM, <rob@xxxxxxxxx> wrote:

Try IPLing and see if it runs dog slow
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=%2Frzajq%2Frzajqcache.htm


Rob Berendt
--
Group Dekko
Dept 1600
Mail to:  2505 Dekko Drive
         Garrett, IN 46738
Ship to:  Dock 108
         6928N 400E
         Kendallville, IN 46755
http://www.dekko.com





From:   Michael Ryan <michaelrtr@xxxxxxxxx>
To:     Midrange Systems Technical Discussion <MIDRANGE-l@xxxxxxxxxxxx>
Date:   03/23/2011 12:41 PM
Subject:        Embedded SQL/Index/Speed/How
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



Ok...a co-worker had a program with an embedded SQL statement,
selecting records with a number of different criteria. It ran dog
slow. I suggested creating an index to remove some of the 'fixed'
criteria. Did that, recreated the program, ran like the wind. Then we
decided to test things out. Deleted the index. Still ran fast. Used an
old copy of the program that was created before the index was made.
Still ran fast. Deleted the index and the program, recreated the
program. Still ran fast.

What happened? Was an access plan created and stored someplace? I
would think deleting the program and index and recreating the program
would remove any consideration of an access path.

Thanks for any thoughts.
--
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.


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