469,296 Members | 2,144 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,296 developers. It's quick & easy.

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 2551
"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 zhoujie | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.