×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I completely disagree with the statement "(Developers shouldn't be worried
about how the database optimizer does it's magic).". In the majority of
AS400, iSeries, or System i development environments where there is not a
person that performs the functions of a Data Base Administrator then the
developers do need to be cognizant of how their SQL development decisions
impact the performance of the system. If the department does have a DBA
that is monitoring those functioning of the database then it is less
important but I feel that the developer should still have a moderate
understanding of the query optimizer decisions. I see time and time again
where developers are choosing to use SQL instead of RLA access without
understanding the implications of their actions.
To:
Rational Developer for IBM i / Websphere Development Studio Client for
System i & iSeries <wdsci-l@xxxxxxxxxxxx>
Subject:
Re: [WDSCI-L] Explain or Show Optimized Indexes
Mike Wills wrote:
In the past, I have used `STRDBG` and `STRSQL` to determine what
indexes to create to improve the speed of my SQL statements. I
remember using iSeries Navigator to do this as well. Is there a way to
do this in RDi?
RDI is a development tool, not a database administration tool.
I wouldn't expect that kind of function to be included.
(Developers shouldn't be worried about how the database optimizer does
it's magic).
david
midrange.com
