We moved from BMC tools for DB2 to CA tools for DB2 in 2013.
They have a interface to support Virtual Indexes. They call is "What If" analysis and "Clone". This feature is very useful, when you think an index might help improve performance of a query but not sure if it'll really help. Or you might think dropping an index will help. This feature helps figure these out.
I've tried using Virtual Index, in DB2 way. But it's cumbersome, time consuming, not user friendly.
Is there any other alternative in CA tools? Is there any plan to bring this feature in the next releases?