SEO

#1 (**permalink**) 02-27-2008, 07:36 AM

hi,

our db2advis is broken and i am trying to find other ways to get
recommended indexes
i tried using command "SET CURRENT EXPLAIN MODE RECOMMEND INDEXES" and
it populated ADVISE_INDEXES table. new indexes recommended by this
command does not have runstats on it.
how can i evaluate new suggested indexes ?
do i have to physically create these indexes and then explain my SQL ?
can i do it without actually creating suggested indexes ?
what is the difference between "SET CURRENT EXPLAIN MODE RECOMMEND
INDEXES"
and "SET CURRENT EXPLAIN MODE EVAULATE INDEXES"
they both seems to fill same kind of information in ADVISE_INDEXES
table.
please suggest me a way to get around functionality of db2advis

regards,
jag

#2 (**permalink**) 02-27-2008, 07:36 AM

"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.

#3 (**permalink**) 02-27-2008, 07:37 AM

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

#4 (**permalink**) 02-27-2008, 07:37 AM

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

set current explain mode recommend indexes