Re: Performance of ODBC vs. other access methods

On 9/6/06, richard@xxxxxxxxxxx <richard@xxxxxxxxxxx> wrote:

Steve, are you alluding that other databases are smart enough to create
their own permanent indexes and views based on what the DB thinks the
access path should be ?

no, Richard, I am referring to what is needed on our system. I
attended an IBM SQL seminar recently and the topics were all on
performance tuning. That got me thinking that gee, if they dont gear
the system down then we would not have to be so focused on tuning our
database and could be taught instead how to write SQL procedures.  The
other recent event that pertains to ODBC performance is IBM just about
doubled the performance, keeping the price the same, of the p5 in
August. Maybe DB2 does not have dynamic index creation and retention
because we share a common DB2 code base with the p5 and that system is
so fast and low priced that they dont need that feature.

-Steve