Thursday, March 11, 2010

IBM XML Index Advisor for DB2

DB2 has an index advisor (part of the DB2 Design Advisor) which helps to identify missing indexes to speed up a given workload. Unfortunately, it lacks pureXML support. The good news is that there is a tool on IBM alphaWorks, called the "IBM XML Index Advisor for DB2 for Linux, UNIX, and Windows".

Give the tool a try and provide feedback to the team (I already did and, e.g., requested more examples).

2 comments:

Anonymous said...

Hello Henrik,

These are indeed good news. In the first days of pureXML beta I spoke with Matthias Nicola about a XML Index Advisor, and he said that with a 9.7 it would be scheduled. At the moment, we need no index. We process every night from 800 stores the data in 2 hours. But it would be an attempt to see what happens. I'll talk to our developers and think of the tool. The XML Index Advisor seems to be tested before it moves into DB2 like db2top. Thanks for the hint.

Best regards,
Joachim Müller

Henrik Loeser said...

Hello Joachim,

speaking in general terms, I see tools and technologies published to alphaWorks for two reasons: One is to make them available in a usable state as early as possible, the second is to see user feedback and to decide whether to make a full product out of them (with the required resources to ensure product quality).

Personally, I would like to see the XML Index Advisor included in the Design Advisor. Thus, any feedback and requests are highly appreciated from your developers.

Henrik

LinkWithin

Related Posts with Thumbnails