db2admin wrote:
> Mark A wrote:
> > "db2admin" <jagdip@gmail.com> wrote in message
> > news:1152309144.135822.255250@s13g2000cwa.googlegr oups.com...
> > > our db2advis is broken
> >
> > This is a blessing in disguise.
> >
> > > please suggest me a way to get around functionality of db2advis
> > >
> >
> > Hire someone who understands DB2 performance tuning and can tune the query
> > with using db2advis.
>
> thanks for your reply mark but you did not answer my question

Sorry, I meant "without" using db2advis.

db2advis will not give you the best optimization of your system. It
often suggests creating indexes that are not needed. It also seems to
(inexplicably) puts columns in descending order when suggesting
indexes, for no discernable reason.