tag:blogger.com,1999:blog-18371456.post2058640652533146978..comments2024-03-26T00:07:20.400-05:00Comments on The Db2 Portal Blog: On Building Appropriate DB2 IndexesCraig S. Mullinshttp://www.blogger.com/profile/17077237739217901780noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-18371456.post-62279782466268090632014-11-15T16:48:14.783-06:002014-11-15T16:48:14.783-06:00Makes some sense as there are a lot of tools out t...Makes some sense as there are a lot of tools out there. This one just happens to be part of DB2 itself, so it is always available.Anonymoushttps://www.blogger.com/profile/16305367990710768836noreply@blogger.comtag:blogger.com,1999:blog-18371456.post-26399192783763655002014-11-15T15:29:20.417-06:002014-11-15T15:29:20.417-06:00Tooling to help create appropriate indexes can be ...Tooling to help create appropriate indexes can be a good idea. I try not to promote any specific tools on the blog unless it is one that I have used (or am currently using) on a job.Craig S. Mullinshttps://www.blogger.com/profile/17077237739217901780noreply@blogger.comtag:blogger.com,1999:blog-18371456.post-78010596851586198422014-11-14T23:11:27.468-06:002014-11-14T23:11:27.468-06:00Just wondering what your thoughts are on the index...Just wondering what your thoughts are on the index advisor tool? When a client says that a particular activity (report or whatever) is slow, I capture a bunch of their SQL statements using a logging function that captures their SQL as they perform their activity, and then use that' as the workload input into the advisor command-line tool. It suggests indexes and generates the code to create them along with an estimate of the expected performance improvement. Seems like a useful addition to your article?Anonymoushttps://www.blogger.com/profile/16305367990710768836noreply@blogger.com