Add interactive menu for Maintained Temporary Indexes (MTIs) for tables in the schemas browser

[ryan-moeller21]

It is possible today to view the MTIs built for tables in a certain library by right-clicking on a table and clicking the "Get MTIs" button. However, it's not possible to do anything with this information besides viewing the MTIs.

It would be great to be able to interact with each MTI. For example, I would like to right-click and create a perm index that matches the definition of a given MTI. ACS can do this today (see below)

[buzzia2001]

Ciao @ryan-moeller21, hope to find you well...

So, let me check if I understood well... You want to replace this view (db2 -> click on file -> get MTIs)

with a new view (always a table) that allows you to get this informations and also allows you to run actions with theese mtis?

My idea is to prepare a table like this one below (obv. changing columns), in case this actions are "create index" and "show stmt" like acs...

What do you think?

[ryan-moeller21]

Hi @buzzia2001, this approach is exactly what I was thinking. A right-click menu would be preferable to me instead of buttons, but if that's not possible, buttons would be a massive step forward in functionality. Thanks for taking a look at this!