Re: Explain or Show Optimized Indexes

Why put a query tool in the IDE?

Or should that not be there either?

If the query tool is there for script development, I can see where
it'd be nice to have VE also. As it is, most of my development is in
Run SQL scripts, then copied and pasted into WDSC, simply because the
query tools in WDSC don't provide access to VE.

Charles

On Thu, Mar 17, 2011 at 4:49 PM, David Gibbs <david@xxxxxxxxxxxx> wrote:

Vern Hamberg wrote:

I hope your tongue was firmly planted in your cheek!

Absolutely not.

I rely on Visual Explain to help me get the best performance out of
the SQL we have in our products. I'm glad we DON'T have DBAs - it
lets me get to the bottom of things faster.

That's fine ... you use the right tool for the job.

IMO: Putting a database performance analysis tool in a IDE is putting it in the wrong place.

david

--
IBM i on Power Systems - For when you can't afford to be out of business
--
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries  (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.