By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,227 Members | 1,025 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,227 IT Pros & Developers. It's quick & easy.

Design Advisor does not recommend indexes !!

P: n/a
Hello,

I am using DB2 UDB v.8.2, with TPC-H 1GB database.

When I use the design advisor, and set a disk space limit of 100 MB,
the design advisor does not recommend anything.

db2advis -l 100 -d TPCH -i c:\thequeries.sql -k OFF -m I -t 10

With another database, I did the same, but with a space constriant of
45 MB, again the advisor did not recommend indexes. Yet, I was able to
create 14 single-column indexes using the 45 MB myself, and improved by
the workload by %10.

Can some one help me here? its just not logical.

Thanks

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"UnixSlaxer" <un********@hotmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
Hello,

I am using DB2 UDB v.8.2, with TPC-H 1GB database.

When I use the design advisor, and set a disk space limit of 100 MB,
the design advisor does not recommend anything.

db2advis -l 100 -d TPCH -i c:\thequeries.sql -k OFF -m I -t 10

With another database, I did the same, but with a space constriant of
45 MB, again the advisor did not recommend indexes. Yet, I was able to
create 14 single-column indexes using the 45 MB myself, and improved by
the workload by %10.

Can some one help me here? its just not logical.

Thanks

The DB2 design advisor is for sissies. Any decent DBA can do better by
themselves.

If you want to see what indexes IBM used when they ran the DB2 benchmarks,
look a the "Full Disclosure Report" for the benchmark test on the
www.tpc.org site. In some cases IBM used "organize by" (which is really
MDC), but if you just use the same columns for regular indexes it should
work about the same.
Nov 12 '05 #2

P: n/a

"UnixSlaxer" <un********@hotmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...
Hello,

I am using DB2 UDB v.8.2, with TPC-H 1GB database.

When I use the design advisor, and set a disk space limit of 100 MB,
the design advisor does not recommend anything.

db2advis -l 100 -d TPCH -i c:\thequeries.sql -k OFF -m I -t 10

With another database, I did the same, but with a space constriant of
45 MB, again the advisor did not recommend indexes. Yet, I was able to
create 14 single-column indexes using the 45 MB myself, and improved by
the workload by %10.

Can some one help me here? its just not logical.

Thanks


Tuning is an art. Why would you want to use robot?
Nov 12 '05 #3

P: n/a
in****@gmx.ch wrote:

Tuning is an art. Why would you want to use robot?

Where i can learn this?
Any tuts available?


Your nearest IBM Education Center also gives yearly Performance Tuning
courses (at least, the EC in Amsterdam does :p).
The course is nice, you forget most the day after, but you get some
Learning Services Student notebooks, which make excellent reference
guides. (+a nice certificate you can hang in your office :S)

-R-
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.