Re: SQL Performance on JDBC

[Dieter Bender <dieter.bender@xxxxxxxxxxxx>]

Larry,

#1 is ok, but not enough
#2 creating each index permanent has disadvantages too, ibm choose to don't do 
so

further more I would have a look to:
- all request > 0.4 seconds
- number of connections made by application (is the pool working well)
- number of database requests per user transaction

Dieter Bender
 

On Mittwoch, 16. Juni 2004 17:07, Larry wrote:
> We use SQL via our Java programs (JDBC).  I have been running the Client
> Access "Detailed SQL Performance Monitor" option.
>
> Generally, after collecting data for some period of time, I check these two
> reports:
>
> 1) Index Advised Information - look at the "Advised Index Keys" column and
> create these indexes.
>
> 2) Index Create Information - look at the columns "Created Index Keys" and
> "Index Advised Key Columns"
>
> Regarding #1, do you agree with me that this is a good practice?
>
> Regarding #2, I am confused at what the system is telling me.  If it had to
> create the index in the "Created Index Keys" column, why wouldn't I just
> want to create those indexes permanently?  And why do the values in "Index
> Advised Key Columns" differ so wildly from the actually created index?  I
> am not sure what to do with this data.
>
> Is there any other key indicator in the detailed data you think I should be
> focusing on?
>
> Thanks,
>
> Larry
>
>
>
> _______________________________________________
> No banners. No pop-ups. No kidding.
> Make My Way your home on the Web - http://www.myway.com
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.

-- 
mfG

Dieter Bender


DV-Beratung Dieter Bender
Wetzlarerstr. 25
35435 Wettenberg
Tel. +49 641 9805855
Fax +49 641 9805856
www.bender-dv.de
eMail dieter.bender@xxxxxxxxxxxx