Forum Stats

  • 3,852,689 Users
  • 2,264,128 Discussions
  • 7,905,118 Comments

Discussions

How to add an index to a materialized view in Data Modeler 3.3

blama
blama Member Posts: 123

Hello everyone,

I'm looking for a how-to to add an index to a materialized view in Data Modeler 3.3.0.747, as I coudn't find a way to do it so far.

I looked here:

Relational Model

Physical Model

Oracle 11g

Materialized Views

"my_mv_name"

"INDEXES" IS NOT HERE IN THE TREE

"Tables" does not include it either

Thank you & Best regards,

Blama

Kent Graziano

Best Answer

  • David Last-Oracle
    David Last-Oracle Member Posts: 1,057 Silver Trophy
    Answer ✓

    Hi Blama,

    You can create a Table with the same name and associate it with the Materialized View (by setting "Implement as Materialized View" in the Physical Model properties for the Table.

    If you set up the Columns and Index on the Table, the Index will be included in the DDL generated for the Materialized View.

    Regards,

    David

    Kent Graziano

Answers

This discussion has been closed.