Re: Embedded SQL/Index/Speed/How

[Michael Ryan <michaelrtr@xxxxxxxxx>]

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.