Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

tuning db2

is there anything comparable to the index tuning wizard of SQL Server in
DB/2? Let me ask another way, is there any automated way for the db/2
database to analyze the type of commands that are being executed on the
database and to create a list of suggested indexes?
Wally
[294 byte] By [Wally McClure] at [2007-11-9 18:51:45]
# 1 Re: tuning db2
"Wally McClure" <wallym@wallym.no.spam.com> wrote:
>is there anything comparable to the index tuning wizard of SQL Server in
>DB/2? Let me ask another way, is there any automated way for the db/2
>database to analyze the type of commands that are being executed on the
>database and to create a list of suggested indexes?
>
>Wally
>
>
Yes ... it is called the DB2 UDB Index Advisor.

Larry
Larry at 2007-11-12 0:01:34 >