View "MATERIALIZED VIEW"

[ed10k]

There is a materialized view.
I do select on this view and would like to see which colums are indexed (i.e. index on the materialized view table).

I do "right click" on MV -> View, but only a window with the "CREATE MATERIALIZED VIEW ..."-statement appears.

How can I see the indexed columns without a direct select from DBS/ALL/USER-View?

 

[Joachim Rupik]

You can try to use a Browser Extender plug-in.

 

[Marco Kalter]

Also, if you open the "References" folder of the materialized view, you can drill down to the underlying table and its properties.

 

[ed10k]

Thanks, that works.

But the detour over the Browser Window is very long. You have to open the Browser Window, locate the materialized view, click "References" and wait.

Can you add a context menu (on right click on the materialized view) for example "View underlying table" or the like?

 

[Joachim Rupik]

Can you add a context menu (on right click on the materialized view) for example "View underlying table" or the like?

Browser Extender can do that.