Can I create index on Materialized views and will it improve query performance in warehouse DB?
Dear All:
Below query "run fast on production but very slow on warehouse DB " - I find it used indexes on production, but maybe Mview full scan at warehouse DB.
It took only seconds on production, but run into 3+ hours in warehouse DB and not finished yet! Question so far -
(1) Can I and will create indexes on Mviews at warehouse DB to speed up performance? Any bad impact which I'm not aware of?
(2) Anything need to modify on master table if create index on Mviews?
It didn't finish in warehouse DB in 3 hours, so I can't paste explain plan this time. Here is its production situation -
Below query "run fast on production but very slow on warehouse DB " - I find it used indexes on production, but maybe Mview full scan at warehouse DB.
It took only seconds on production, but run into 3+ hours in warehouse DB and not finished yet! Question so far -
(1) Can I and will create indexes on Mviews at warehouse DB to speed up performance? Any bad impact which I'm not aware of?
(2) Anything need to modify on master table if create index on Mviews?
It didn't finish in warehouse DB in 3 hours, so I can't paste explain plan this time. Here is its production situation -
0