tag:blogger.com,1999:blog-5942052796969657606.post3777400745349851663..comments2023-03-12T08:56:39.925-05:00Comments on Db2 for i: More Advice! Is this Good OR Bad?Unknownnoreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5942052796969657606.post-77808190249833632942014-08-05T14:59:23.816-05:002014-08-05T14:59:23.816-05:00Hi Cliff, great question, with an easy answer... ...Hi Cliff, great question, with an easy answer... check out either the graphical interface System i Navigator - Show Indexes (for a table) feature or query the QSYS2.SYSPARTITIONINDEXES catalog view. Both will provide you with information about the last time the index was used.Mike Cainhttps://www.blogger.com/profile/01481223716996299215noreply@blogger.comtag:blogger.com,1999:blog-5942052796969657606.post-65579137961565038542014-08-05T12:40:00.534-05:002014-08-05T12:40:00.534-05:00I've used the easily accessible index (creatio...I've used the easily accessible index (creation) advice. Is there anything that is likewise available for suggesting existing indexes that are unused or rarely used that can go MAINT(*DLY) or be decommissioned altogether?Cliff Dowellhttps://www.blogger.com/profile/03954773009346941966noreply@blogger.com