I created a few materialized views containing only joins. The views are created with refresh force on demand and enable query rewrite. In init.ora, query_rewrite_enable = true and query_rewrite_integrity = trusted. After the materialized view created, I analyzed it. Then, I check the explain plan for the same query I created the materialized view to see if it's using the mv. But I don't see mv in the path. I ran the same query I used to create the mv. It took about the same time as I created the mv.
It seems to me the mv does not work as it suppose to be. Am I missing anything?