If
you
are
thinking
about
using
or
have
used
SQL
on
the
iSeries,
here's
some
performance
background
on
how
the
iSeries
database
engine
handles
SQL
requests.
This
session
covers
performance
concepts
that
apply
to
any
SQL
interface
(embedded
SQL
in
applications,
JDBC,
ODBC,
etc.).
In
this
session,
learn:
1.
The
basics
of
access
plans,
open
data
paths
(ODPs),
and
reusable
ODPs.
2.
The
direct
performance
effects
of
these
concepts.
3.
Other
tips
on
how
to
code
high-performing
SQL
on
the
iSeries.
|