Re: Index question

Just bear in mind that YMMV.
Creating the indexes may make the SQL select more efficient, but you may
gain only fractions of a second improvement based on the number of records
in the file and number of records selected.

You should look at the statistics for the SQL Statement before and after
the indexes are created to determine the run time for each.


On Mon, Jan 21, 2013 at 1:51 PM, <rob@xxxxxxxxx> wrote:

See Run SQL Scripts below?
I expanded my system. I expanded Databases. I right clicked on the
database associated with my system. Normally there's only 1. This may
differ if you do some 'interesting' things with WRKRDBDIRE or independent
ASPs. Once I right clicked my database I get a drop down list. One of
those options is Run SQL Scripts. Perhaps you right clicked on the wrong
thing (or you're left handed and changed your mouse properties).




Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
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: "James H. H. Lampert" <jamesl@xxxxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 01/21/2013 01:34 PM
Subject: Re: Index question
Sent by: midrange-l-bounces@xxxxxxxxxxxx



On 1/21/13 9:41 AM, Tom E Stieger wrote:

Hope this helps.

1. Open System I navigator
2. Expand My AS/400 Connections
3. Expand the server you are connected to
4. Expand Databases
5. Right-Click on the database name for your system
6. Select Run SQL Scripts
7. Paste your SQL into the run SQL scripts
8. Select VisualExplain -> Explain

Hmm. I don't see "Run SQL Scripts."

But be that as it may, just running a STRSQL in the debugger, and
feeding it a hand-coded reconstruction of the generated SQL being run by
the application, got me some index suggestions that I implemented, and
that may have speeded some things up, just a bit.

--
JHHL

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