Re: Steve Ballmer says IBM is not innovating lately

Hi Bryan,

Have you looked at Visual Explain in Run SQL Scripts?

Remember, you already have all of this, no upgrades required, no extras,
just install and use.

HTH

Paul

----- Original Message -----
From: "Bryan Merrell" <merrells@xxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
Sent: Monday, July 11, 2005 6:39 PM
Subject: RE: Steve Ballmer says IBM is not innovating lately


> I have found that I like STRSQL for optimizing my SQL's manually. I can
make
> an SQL run faster buy finding out bottle necks using tools to display them
> and then manually tweaking the SQL for desired performance. Granted, this
is
> for multiple join SQL's. It is till fun to see when a small change in the
> SQL results in a 1min performance boost.  :) I have not found a tool yet
> that can create an SQL that can run faster than one that I have create in
> this way.
>
> Bryan
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Tuohy
> Sent: Monday, July 11, 2005 11:19 AM
> To: Midrange Systems Technical Discussion
> Subject: Re: Steve Ballmer says IBM is not innovating lately
>
> Or better still, use the Databases function in iSeries navigator to
actually
> create the tables, views etc. Use Run SQL Scripts to test it, use Generate
> SQL to generate an amendable script.
>
> Why use STRSQL?
>
> Paul
>
>
>
> --
> 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.
>
>