471,853 Members | 1,625 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,853 software developers and data experts.

set current explain mode recommend indexes

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

Jul 7 '06 #1
3 2640
"db2admin" <ja****@gmail.comwrote in message
news:11**********************@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.
Jul 7 '06 #2

Mark A wrote:
"db2admin" <ja****@gmail.comwrote in message
news:11**********************@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

Jul 10 '06 #3

db2admin wrote:
Mark A wrote:
"db2admin" <ja****@gmail.comwrote in message
news:11**********************@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.

Jul 10 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by DMD | last post: by
3 posts views Thread by UnixSlaxer | last post: by
16 posts views Thread by romicva | last post: by
1 post views Thread by awebguynow | last post: by
5 posts views Thread by Spoon | last post: by
1 post views Thread by w.l.fischer | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.